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@xxxxxxxx
<amit.poddar@xxxxxxxx> 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

Other related posts: