Re: Group by and Oracle

From: Telemachus <Zaka_at_twibbles.99.net>
Date: Tue, 1 Mar 2005 10:37:44 -0000
Message-ID: <YBXUd.48588$Z14.35783@news.indigo.ie>

Can the group by <column> be satisfied entirely from the index ? I think not. You are selecting at least one other column in the select-list.

-> foreach group by column must sort the <other columns>

--> how does an index help here ?

"Iain William Wiseman" <bibble_at_paradise.net.nz> wrote in message news:422419d5$1_at_clear.net.nz...
> Hi there,
>
> When I do an explain plan there is always a sort regardless of the index
> being available when I use a group by.
>
> Is this OK?
>
> Thanks,
>
> Iain
> New Zealand
Received on Tue Mar 01 2005 - 04:37:44 CST