Re: group by and sorting

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 2 Jun 2005 20:43:49 +0000 (UTC)
Message-ID: <d7nr25$47m$1@nwrdmz02.dmz.ncs.ea.ibs-infra.bt.com>

I suspect the thing you saw was an execution plan where Oracle used an index to acquire data in the correct order for an aggregate, and therefore reported

sort (group by nosort).

You cannot 'tell' Oracle not to sort for a group by - but Oracle can discover that there is an efficient access path that allows it to avoid sorting.

-- 
Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated April 5th 2005






"Eugene" <epipko_at_hotmail.com> wrote in message 
news:1117573455.967730.316920_at_f14g2000cwb.googlegroups.com...


> Hi all,

> Is there a way to "tell" Oracle not to sort when it's doing GROUP BY? I

> think I saw something like ... group by nosort somewhere.

>

> Eugene

>

Received on Thu Jun 02 2005 - 15:43:49 CDT