Re: Fake index

<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:
| > <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

The OP did not say he executed a query, he only said he got an ORA-08114 error. You can't really use a virtual index in a query, you just seem to use it in explain plan/autotrace. This is the purpose of virtual indexes. If you can really use them why do you create a real index anymore?

Regards
Michel Cadot Received on Sat Jan 22 2005 - 23:02:22 CST