|
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.
Navigation:
[Reply to this message]
|