Re: Help !! Index creation
Date: 1996/03/22
Message-ID: <3152C56C.7A7B_at_ffsdev.ml.com>#1/1
Raj Rangarjan wrote:
>
> Hi,
> I had two question regarding index creation in oracle and was
> hoping someone could answer them:
> 1. Does it matter what order the indexes are created , if two
> or more fields in a table are indexed?
> 2. Does the order of the fields in the table(ie the order they
> are specified when the table is created) matter when indexes
> are created on this field?
> Any help would be appreciated . Please post your replies here or send
> them to raj_at_cs.clemson.edu
>
> Thanks
>
> --
> *******************************************
> -Rajasekaran Rangarajan
> -Administrative Progamming Services
> -Clemson University
> -Ph:(864) 656 0731/ Fax:(864) 656-0122
Hi Raj,
Your posting is unclear as to what you are looking for.
Are your indexes individual or composite ?
ie. in table A (C1, C2, C3)
Index 1 is on C1,
Index 2 is on C2
In the above: the order is not important.
Or is it
Index 3 is on (C1, C2):
In this case the order does matter.
One thing for sure, the indexes are not dependent on the order of columns when the table was created.
-- Subi Hanagal - Oracle DBA Financial Planning Systems Email: subi_at_ffsdev.ml.com, subi_at_gnn.com Phone: 908-297-8240 (R), 908-627-6493 (W)Received on Fri Mar 22 1996 - 00:00:00 CET