"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:37:06 CDT
