I most certainly didn't say, or mean to imply that.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
"Alan" <alan_at_erols.com> wrote in message
news:bkcd48$43sa$1_at_ID-114862.news.uni-berlin.de...
> 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 - 10:26:28 CDT
