RSS Feed

Method R Discussion Group

I hear that Oracle rewrites the queries and some of the predicates.  How does this approach work in that case?

To get more information on how Oracle transforms queries, you can download and review our webinar entitled "Query Transformation: Why, When and How Does the Optimizer Rewrite my Query?" at https://portal.hotsos.com/events/webinars/free-webinar-9/.

As far as how the approach discussed in this webinar works with query transformation, the answer is "great"!  The way you see transformations that Oracle does to your query is by looking at the predicate information (provided with explain plan output) and also by reviewing the plan operations as a whole.  Even if Oracle rewrites your query in some way, the plan and STAT lines will reflect what Oracle did.  Nothing changes in how you use explain plan and STAT lines to work out what you need to.