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: Wrong index used

Re: Wrong index used

From: john gallet <john.gallet_at_wanadoo.fr>
Date: Fri, 18 May 2001 08:38:14 GMT
Message-ID: <3B04E20C.2FB4EB33@wanadoo.fr> 






Hi there,



> How can we fix this and what is the reason?




First of all I'd try updating the statistics. Anyway, it can only help.



Do that with dbms_utility.analyze_schema for all the tables of the user,
and check out the doc for doing that on the table and the indexes only.



HTH



JG
Received on Fri May 18 2001 - 03:38:14 CDT












Original text of this message













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