Re: Help !! Index creation

From: Subi Hanagal x6493 <subi_at_ffsdev.ml.com>
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

Original text of this message