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

Home -> Community -> Usenet -> c.d.o.server -> Re: Fake index

Re: Fake index

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sun, 23 Jan 2005 12:29:19 +0000 (UTC)
Message-ID: <ct05av$5t8$1@hercules.btinternet.com>

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

Original text of this message

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