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.


>
>

[Back to original message]