or even experiments.
"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3d22c5c2$0$233$ed9e5944_at_reading.news.pipex.net...
> "Anurag Varma" <avdbi_at_hotmail.com> wrote in message
> news:58qU8.7531$68.204409_at_news4.srv.hcvlny.cv.net...
> > True. Oracle does state that distinct is not guaranteed
> > to return ordered result sets.
> > A case would be when you are using the PQO.
> > At least in pre-8i, for non-PQO, distinct does return
> > an ordered resultset since Oracle does a *sort* to find
> > the distinct rows.
> >
> > Having said that .. :) I agree completely with Niall.
> > I should know better than suggesting a solution which
> > might fail in later Oracle releases or in case of a configuration
> change...
> >
> > Niall, I think the INDEX hint has the exact same pitfall with PQO. It
too
> > does not
> > guarantee an ordered resultset (correct me if wrong?).
> >
> > Anurag
>
> You could be correct it seems reasonable. I haven't done any expertiments
> with PQ.
>
>
> --
> Niall Litchfield
> Oracle DBA
> Audit Commission UK
> *****************************************
> Please include version and platform
> and SQL where applicable
> It makes life easier and increases the
> likelihood of a good answer
>
> ******************************************
>
>
Received on Wed Jul 03 2002 - 04:51:48 CDT
