Re: Tuning group by sql

Kevin,

Have you run the ANALYZE command on the table and its indexes? Maybe Oracle is using the rule-based optimizer because statistics aren't available. HTH

Mike S.

On Tue, 15 Feb 2000 21:32:07 GMT, 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.
Received on Thu Feb 17 2000 - 00:00:00 CST