D. Robbins wrote:
> Is there any documentation available on the default query result
> ordering in the absence of an ORDER BY clause? I looked through the
> Oracle docs and could not find much. I do not plan to depend on this
> behavior but I am curious on how it works. Thank you.
There is none. The order of returned rows depends on the chosen access
plan as well as runtime behavior in case of parallelism.
There is one exception: CONNECT BY queries. But even those only serve a
partial order in the absence of an ORDER BY.
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab
Received on Fri Mar 02 2007 - 21:02:33 CST
