Re: Fake index

"Michel Cadot" <micadot{at}altern{dot}org> wrote:
> <DMina_at_laiki.com> a écrit dans le message de
> news:1106424133.129103.98370_at_c13g2000cwb.googlegroups.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/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?

Xho

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