Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: oracle create index
"John" <nihal_at_newmexico.com> wrote in message
news:bfif80$87m$1_at_reader2.nmix.net...
> Ouch, I was worried this would be the answer. I have a script written that
> could easily build all the indexes with the table name concatinated on the
> front or something of the like, however what I am trying to avoid is
> rewriting all the other software that makes queries using these index names.
>
If you are targeting this software to later versions of Oracle (8i onwards), may I strongly suggest you bite the bullet and eliminate the index names from the code? That is a no-no at the best of times and with the latest CBO versions even more!
-- Cheers Nuno Souto wizofoz2k_at_yahoo.com.au.nospamReceived on Tue Jul 22 2003 - 05:56:29 CDT