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: <xhoster_at_gmail.com>
Date: 24 Jan 2005 17:46:10 GMT
Message-ID: <20050124124610.680$Is@newsreader.com>


"Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <xhoster_at_gmail.com> a écrit dans le message de
> news:20050122221140.418$4E_at_newsreader.com...
> | "Michel Cadot" <micadot{at}altern{dot}org> wrote:
> | >
> | > Have a look at:
> | >
> | > http://www.databasejournal.com/features/oracle/article.php/3413961
> |
> | 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?
> |

>

> The OP did not say he executed a query, he only said he got an ORA-08114
> error.

I wasn't refering to the OP, but to one of the examples in the link you posted.

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB
Received on Mon Jan 24 2005 - 11:46:10 CST

Original text of this message

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