Re: retrieve rows in a specified order
Date: Sun, 21 Dec 2003 18:27:39 GMT
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.Received on Sun Dec 21 2003 - 19:27:39 CET