Re: Tuning group by sql

From: <michael_bialik_at_my-deja.com>
Date: 2000/02/16
Message-ID: <88f4lo$st9$1@nnrp1.deja.com>#1/1

Hi.

Post query and EXPLAIN plan.

Michael.

In article <88cgkn$1cr$1_at_nnrp1.deja.com>, kevinator_ca_at_my-deja.com wrote:
> 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.
>

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