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 -> Query not using indexes

Query not using indexes

From: hastenthunder <hastenthunder_at_hotmail.com>
Date: Wed, 7 Jul 2004 18:26:43 -0400
Message-ID: <vL_Gc.576$Ny6.1485@mencken.net.nih.gov> 





Hi,



A query of mine in Oracle 9i R2 chooses to perform a full table scan of 1
million row instead of using the index.


I'm using CBO and just computed the statistics for the table.



Can someone help?



Thanks
Received on Wed Jul 07 2004 - 17:26:43 CDT












Original text of this message













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