Posted by Greg D. Moore \(Strider\) on 12/19/06 12:42

"Russ Rose" <russrose@hotmail.com> wrote in message
news:rIKdnRRxk8OS2BrYnZ2dnUVZ_s-rnZ2d@comcast.com...
>>
>> SQL has one data structure, tables.
>
> And indexes are what exactly?

An index, not a data structure.
>
>>
>> Tables are not ordered.
>
> Even clustered ones?

Not even clustered ones.

The engine is free to return data in whatever order it wishes.

In theory if you did a select * from FOO and it already had the last 100
records physically stored last in cache it could return those before
returning the rest.


>
>>
>> Therefor the fact that SQL 2000 allowed the above syntax is basically
>> "wrong".
>
> Yet it works...

In SQL 2000. But not SQL 2005 or presumably later versions.

[Back to original message]