Re: Help !! Index creation
From: <deangup_at_admin.ci.seattle.wa.us>
Date: 1996/03/26
Message-ID: <4j9k5i$49r_at_lal.interserv.net>#1/1
Date: 1996/03/26
Message-ID: <4j9k5i$49r_at_lal.interserv.net>#1/1
> raj_at_cs.clemson.edu (Raj Rangarjan) writes:
> 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?
No, as I understand it. In DB2 the first index is the default clustering index, predisposing the DBMS to
physically order rows per that index. But Oracle does not appear to care about physical row order as far
as I've been able to tell.
> 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?
No, IMHP.
- Paul de Anguera, City of Seattle HRIS