Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> optimizer rewriting query

optimizer rewriting query

From: <amit.poddar_at_yale.edu>
Date: Fri, 11 Mar 2005 20:28:12 -0500
Message-ID: <1110590892.423245ac7288b@www.mail.yale.edu>


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
Received on Fri Mar 11 2005 - 20:31:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US