Re: optimizer rewriting query

you cannot see the re-written query, but only thing you can see is the access plan. As Karen mentioned, you can access those views to see in-memory plans.

Raj

On Sat, 12 Mar 2005 18:27:22 -0500, amit.poddar_at_yale.edu <amit.poddar_at_yale.edu> wrote:
> Does that mean that
> we will have to reverse engineer the rewritten sql statement indirectly
> from access and filter predicates ?
>
> This would be very difficult in case of unnested subqueries and view
> merging.
>
> I have a vague recollection somebody mentioned a event for this
> thats why I asked this question.
>
> amit

--
http://www.freelists.org/webpage/oracle-l