Re: order by question

From: <>
Date: Thu, 23 Oct 2008 17:34:05 +0200
Message-ID: <>

On Thu, 23 Oct 2008 07:34:51 -0700 (PDT), wrote:

>I have not been able to get a resultset which is unsorted acording to
>x.z but need to know that this would not happen in a productive

By definition all SQL prodiuces a set. The set is always an *unordered* collection *by design*, because that is mathematical theory.
Ergo: Oracle does NOT guarantee any resultset is according to any order, when there is no order by clause in the top level of the query. It would be very silly to 'rely' on a specific ordering, and raises suspicions your 'productive environment' is not so productive, as it is processing a set as a bunch of records. Which it shouldn't as that wouldn't scale.

Sybrand Bakker
Senior Oracle DBA
Received on Thu Oct 23 2008 - 10:34:05 CDT

Original text of this message