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 -> One-field INDEX performance VS multiple fields index

One-field INDEX performance VS multiple fields index

From: <michael_bialik_at_my-deja.com>
Date: Sun, 01 Aug 1999 20:55:22 GMT
Message-ID: <7o2c7o$cm6$1@nnrp1.deja.com> 





Hi.



 Is there any difference accessing Oracle table through
 index containing one field ( NUMBER(8)) only or through another
 index containing 5 or 6 fields ( including VARCHAR2 ) assuming
 that the number of selected rows is equal in both cases?



 I couldn't find any reference in Oracle documentation.



 Thanx. Michael.




Sent via Deja.com http://www.deja.com/



Share what you know. Learn what you don't.
Received on Sun Aug 01 1999 - 15:55:22 CDT












Original text of this message













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