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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: SELECT Output Default Ordering ?

Re: SELECT Output Default Ordering ?

From: Daniel Fink <daniel.fink_at_sun.com>
Date: Wed, 25 Jun 2003 07:51:44 -0700
Message-ID: <F001.005B92C3.20030625072016@fatcity.com>


It depends on the access path and any other implicit sorting.

Access path - on a full table scan, the data is returned in the physical order it is stored in the object. An index scan will return the data sorted according to the rule of the index.
Implicit sorting - distinct will cause an implicit sort, as will group by.

VIVEK_SHARMA wrote:
>
> When NOT Giving any Order by Clause , How is the Output of the SELECT Clause ordered
> by Default ?
> Assuming There exists a Unique index on the Table
>
> Is some Rule followed ?
>
> NOTE Records may have been INSERTED into the Table in some manner differing
> from the Order of the data of the Unique index Key fields.
>
> Thanks
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net
> --
> Author: VIVEK_SHARMA
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).begin:vcard
n:Fink;Daniel
tel;cell:303.808.3282
tel;work:303.272.3225
x-mozilla-html:TRUE
adr:;;;;;;
version:2.1
email;internet:[EMAIL PROTECTED]
title:DB Services Lead
x-mozilla-cpt:;-4832
fn:Daniel Fink
end:vcard Received on Wed Jun 25 2003 - 09:51:44 CDT

Original text of this message

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