Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: GROUP BY disables indexes and parallel query
On 7 Apr 1997 22:44:44 GMT, "Dragon Fly" <dfly_at_infinet.com> wrote:
>Here is what I've got:
>SELECT A, B, C from MYTABLE WHERE A<=5 and B=9701;
>runs for 10 secs on 12-million row MYTABLE;
>
>But when I do
>SELECT A,B,COUNT(*) FROM MYTABLE WHERE A<=5 AND B=9701 GROUP BY A,B;
>runs for 20 mins.
>
>Looks like GROUP BY clause disables both indexes and parallel query on
>MYTABLE.
>Why is that and how to avoid it?
>
>Thanks,
>Sergei
What's the number of rows that this query returns? Received on Sun Apr 13 1997 - 00:00:00 CDT