Tuning group by sql

Hello Ora-People,

   I'm using oracle 8i. I have a query that scans a large table (about 100,000 and growing daily) The query uses a GROUP BY clause. When I do the explain plan, I noticed that my indexes aren't being used at all. I have two fields in the group by clause, i created 3 indexes, one with for each field and one for the combination of the two but nothing. If anyone know the best way to the best way to tune a query group by clause, please let me know.

Kevin English

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 15 2000 - 00:00:00 CST