"Spendius" <spendius_at_muchomail.com> wrote in message
news:aba30b75.0309180158.3c65f399_at_posting.google.com...
> Hi,
> I'd like to know if someone knows how to specifically
> tune queries involving sorts and/or using GROUP BY functions.
> Are there particular hints for that purpose ? Apart from
> playing with the sort area size, do you know any other
> feature or way of improving this category of queries ?
>
> Thanks.
> Spendius
Think about the size of the rowset that you are sorting, you might well find
that a different order of joing results in you sorting 100 rows instead of
10 million.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
Received on Thu Sep 18 2003 - 05:36:45 CDT
