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 -> Index usage

Index usage

From: Guruju,Narendra <NGURUJU_at_cerner.com>
Date: Fri, 3 May 2002 13:15:55 -0500
Message-ID: <D15ED542E12BD3119FFE00805F6551F00DED82D9@mailwhqnews.cerner.com> 





With out putting a hint in the query, is it possible to make a query
choose a particular index. The query is in a 3rd party application and
can not be modified, but the testing shows that if it uses a different
index on the table, it would run lot faster. Also the optimizer mode
used by the application is RULE.



TIA,



Narendra
Received on Fri May 03 2002 - 13:15:55 CDT












Original text of this message













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