Re: The horse race

From: Bob Hairgrove <invalid_at_bigfoot.com>
Date: Tue, 21 Feb 2006 19:05:53 +0100
Message-ID: <sflmv11dq3u6319q3b46pd4k0eoqsm4jg9@4ax.com>

On Tue, 21 Feb 2006 10:56:13 +0100, Bob Hairgrove <invalid_at_bigfoot.com> wrote:

>Cursors are always sorted, but relations are not.

Clarification:
Cursors always have an ordering of some kind, even if not explicitly specified by an "ORDER BY" clause -- in which case it will probably, but not necessarily, reflect the physical storage order of the data.

Relations are not sorted at all.

--
Bob Hairgrove
NoSpamPlease_at_Home.com

Received on Tue Feb 21 2006 - 12:05:53 CST