Re: GROUP BY & implicit sorts

"Charlie Edwards" <Charlie3101_at_hotmail.com> wrote in message news:db479d88.0207240608.698779d7_at_posting.google.com...
> > See
> >
> >

http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=36886d96.28433695%40 192.86.155.100&rnum=7
> >
> > for an example of group by not being the same as order by. Indexes and
> > parallel query may well screw up your assumption. .
> >
>
> I assume nothing anymore!
>
> Thanks very much for this, Niall.
> Maybe this should have been in the list of "Oracle Myths" from a few weeks
ago.

It is a very good candidate indeed.

>
> But I wonder, was it _ever_ the case that GROUP BY did implicit sorts?

I rather suspect that the idea comes from the fact that group by often/usually sorts.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer

******************************************