RE: optimizer rewriting query

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

Quoting Karen Morton <Karen.Morton_at_hotsos.com>:

> You can check the access_predicates and filter_predicates columns in
> your plan table (either PLAN_TABLE or V$SQL_PLAN) if you are using
> version 9 and above.
>
>
> Karen Morton
> Hotsos Enterprises, Ltd.
> www.hotsos.com
>
>
> ----- Original Message -----
> From: amit.poddar_at_yale.edu
> Sent: Fri Mar 11 17:27:52 PST 2005
> To: oracle-l_at_freelists.org
> Subject: optimizer rewriting query
>
>
> Hi,
>
> We can use 10053 trace to list all the optimizer calculations and
> decesions about the query plan.
>
> But is there any event to check whether the optimizer has rewrittent
> our
> query, and if yes then to see the rewritten query.
>
> thanks
> amit
> --
> http://www.freelists.org/webpage/oracle-l
>

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