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: oracle create index

Re: oracle create index

From: Noons <wizofoz2k_at_yahoo.com.au.nospam>
Date: Tue, 22 Jul 2003 20:56:29 +1000
Message-ID: <3f1d1c61$1$31925$afc38c87@news.optusnet.com.au>


"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.nospam
Received on Tue Jul 22 2003 - 05:56:29 CDT

Original text of this message

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