Home -> Usenet -> comp.databases.oracle -> ORACLE optimiser question

ORACLE optimiser question

From: Gene Gurevich <geneg_at_umich.edu>
Date: 1996/06/13
Message-ID: <Pine.SOL.3.91.960613133208.11744A-100000_at_stargate.rs.itd.umich.edu>#1/1 







        I have a query: 



SELECT FILED1, count(*)


FROM   TABLE1



GROUP BY FILELD1;


The TABLE1 has an index on FILELD1. The ORACLE optimizer (7.1), however, does
not use this index, accrording to the analyze statement, rather it does a 
FULL table search.. . Does anyone know why?



TIA

Received on Thu Jun 13 1996 - 00:00:00 CEST












Original text of this message