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

Home -> Community -> Usenet -> comp.databases.theory -> Re: retrieve rows in a specified order

Re: retrieve rows in a specified order

From: Christopher Browne <cbbrowne_at_acm.org>
Date: Sun, 21 Dec 2003 18:27:39 GMT
Message-ID: <vClFb.933$d%1.248095@news20.bellglobal.com>


Martha Stewart called it a Good Thing when Paul <paul_at_not.a.chance.ie> wrote:
> paul_at_not.a.chance.ie says...
>> SELECT * FROM My_Table ORDER BY Order_By_Field
>
> Oh, yes, and put an index on the field.

That's typically optional, albeit useful from a performance perspective.

RDBMSes usually include some sort of "sort engine" to cope with what ordering may be requested...

-- 
(format nil "~S@~S" "cbbrowne" "acm.org")
http://www3.sympatico.ca/cbbrowne/nonrdbms.html
Jury  -- Twelve  people  who  determine which  client  has the  better
lawyer.
Received on Sun Dec 21 2003 - 12:27:39 CST

Original text of this message

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