Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Tuning group by sql

Tuning group by sql

From: <kevinator_ca_at_my-deja.com>
Date: 2000/02/15
Message-ID: <88cgkn$1cr$1@nnrp1.deja.com>#1/1

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

Original text of this message

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