"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