Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Index: order of fields

Index: order of fields

From: Jenda Krynicky <Jenda_at_Krynicky.cz>
Date: Mon, 21 Feb 2000 09:30:28 GMT
Message-ID: <1104_951125428@way> 





What is the recomended order of fields in an index? 
I think it does matter right?



Suppose I have these three fields I want to include in an index :
 Country : 'C' or 'S'


 Year : 1993-2000


 AGB : 1500 - 1700 (approx ... it's a number of weeks since some date)



Now is it better to build the index with this order or just the oposite .. or some other?



Thanks, Jenda


http://Jenda.Krynicky.cz


Received on Mon Feb 21 2000 - 03:30:28 CST












Original text of this message













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