Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Default Query Result Ordering Details

Re: Default Query Result Ordering Details

From: Serge Rielau <srielau_at_ca.ibm.com>
Date: Fri, 02 Mar 2007 22:02:33 -0500
Message-ID: <54s6qcF21qul6U1@mid.individual.net>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US