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 -> Advice on Indexes please?

Advice on Indexes please?

From: harry <a_at_abc.com>
Date: Wed, 07 Nov 2001 10:39:29 GMT
Message-ID: <dj3iuto2j3uucoa7ms9li9o3vkmdhvdt3t@4ax.com> 





In general should any columns that appear in a WHERE clause have a index created for them?



Also should the same rule apply if they appear in the ORDER BY part aswell?



Any other tips?



many thanks



harry
Received on Wed Nov 07 2001 - 04:39:29 CST












Original text of this message













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