"Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <DMina@laiki.com> a écrit dans le message de
> news:1106424133.129103.98370@c13g2000cwb.googlegro ups.com...
> | Hello people,
> |
> | I have this strange error:
> |
> | ORA-08114: can not alter a fake index
> |
> | The only solution searching in the internet (metalink, groups) that I
> | found is to drop the index.
> |
> | Anyone encountered this before?
> |
> | Thanks
> |
>
> Have a look at:
>
> http://www.databasejournal.com/featu...le.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?

Xho

--
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service $9.95/Month 30GB