This is just another example of explain plan (invoked
by autotrace) giving you a plan that did not (or in
this case could not) happen.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Dec 23rd 2004
> <xhoster_at_gmail.com> a écrit dans le message de
> news:20050122221140.418$4E_at_newsreader.com...
> |
> | Interesting. I see how you can use a fake index to trick the CBO
> | into given you a hypothetical execution path, but in that example
> | the query was actually run. How do you actually run a hypothetical
> | execution plan?
> |
> | Xho
> |
Received on Sun Jan 23 2005 - 06:29:19 CST
