Re: retrieve rows in a specified order

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_at_~S" "cbbrowne" "acm.org")
http://www3.sympatico.ca/cbbrowne/nonrdbms.html
Jury  -- Twelve  people  who  determine which  client  has the  better
lawyer.