Re: Need some clarification

"Dhanaraj M" <Dhanaraj.M@Sun.COM> wrote
>
> 2. *Invalidate prepared queries, like INSERT, when the table 
> definition is altered
>
> *Invalidation means recompilation or deletion of the prepared stmt 
> here.*
> *Both the items look similar. i.e) needs recompilation of the query 
> after altering the table.
> It is right?*
> *

Yes, IMHO the basic idea is like that - the difficulty is that we are 
lack of efficient object tracking mechanism, so that when an underlying 
object is changed, all the prepared plans should be invalidated.

Regards,
Qingqing