|
|
Posted by Greg D. Moore \(Strider\) on 12/21/06 04:07
"Russ Rose" <russrose@hotmail.com> wrote in message
news:uI-dnZGqeoS1ahTYnZ2dnUVZ_tSunZ2d@comcast.com...
> Is it different stating as one word?
>
> It has structure, defines structure, and contains data. Just like a table.
Yes.
It is not just like a table.
Tell you what, create an index w/o a table and then get back to me.
>
>>
>>>
>>> What value would a "covering" index be if that were true?
>>
>> Again, an index doesn't guarantee the logically returned order.
>>
>> First of all ask youself, what does order mean? Is it the Primary Key?
>> Your covering index? Or something else?
>>
>> What if you have an IDENTITY column and a Primary Key, which is the
>> correct "order".
>
> The physical order of the rows is maintained by the clustered index.
> Without that it is an unordered "heap" table, which is what you seem
> intent on describing all tables as.
No, that's what Codd and Date defined a table as.
>
> Interesting, yet pointless discussion. Going on vacation. Hope you all
> have a great holiday!
I wouldn't say entirely pointless.
Btw, if you're a geek like me, I recommend:
The Database Relational Model: A Retrospective Review and Analysis : A
Historical Account and Assessment of E. F. Codd's Contribution to the Field
of Database Technology by CJ Date.
>
>
Navigation:
[Reply to this message]
|