Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: GROUP BY & implicit sorts
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message news:<3d3e65c3$0$234$ed9e5944_at_reading.news.pipex.net>...
> "Charlie Edwards" <Charlie3101_at_hotmail.com> wrote in message
> news:db479d88.0207240019.54e7b6f9_at_posting.google.com...
> > This is just an academic question.
>
> Oh no it isn't
> >
Well, it is an academic question for me, as I don't rely on it anymore!
>
> See
>
> http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&selm=36886d96.28433695%40192.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.
But I wonder, was it _ever_ the case that GROUP BY did implicit sorts?
CE Received on Wed Jul 24 2002 - 09:08:38 CDT