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 -> Re: How come oracle is always using only one of my indexes ?

Re: How come oracle is always using only one of my indexes ?

From: Brian Peasland <oracle_dba_at_qwest.net>
Date: Wed, 22 Aug 2001 20:43:22 GMT
Message-ID: <3B84196A.355F302D@qwest.net> 



 


> AFAIK, Oracle will neever use more than one index on one table in one

> query.




Correct!



>  It is much better to fetchs the rows via one index scan and then

> filter those who do not satisfy the other clauses.




That's exactly why you want to use the index that has the most distinct
values.



HTH,



Brian
Received on Wed Aug 22 2001 - 15:43:22 CDT












Original text of this message













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