Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: SQL hints/ways of enhancing sort/GROUP BY queries...
IOW use RBO! :)
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3f698abe$0$15775$ed9e5944_at_reading.news.pipex.net...
> "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 - 08:48:59 CDT