Re: index
From: Bob Badour <bbadour_at_pei.sympatico.ca>
Date: Mon, 28 Jul 2008 23:43:58 -0300
Message-ID: <488e83f2$0$4036$9a566e8b_at_news.aliant.net>
>>"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message
>>news:488de63f$0$4041$9a566e8b_at_news.aliant.net...
>>
>>>aarklon_at_gmail.com wrote:
>>>
>>>
>>>>Hi all,
>>>>
>>>>I read the following in a book
>>>>
>>>>1) we can have several non clustered indexes on a table , but we can
>>>>have only one clustered index per table
>>>>
>>>>2) index on the primary key can be clustered or non clustered
>>>>
>>>>now my question is
>>>>
>>>>1) to what extent these statements are true ?
>>>
>>>To the extent the statements accurately describe the physical
>>>implementation of a particular dbms, they are true.
>>>
>>>Theoretically, one can have multiple clustered indexes at the cost of
>>>duplicating the data, which of course incurs a cost. Vendors typically
>>>assUme nobody would ever want to incur that cost.
>>
>>This is bunk. Badour is an idiot. Where there is a clustered index, that
>>index /is/ the table--that is, the table is physically stored using whatever
>>data structure is in use for indexes--probably b-trees.
Date: Mon, 28 Jul 2008 23:43:58 -0300
Message-ID: <488e83f2$0$4036$9a566e8b_at_news.aliant.net>
Evan Keel wrote:
> "Brian Selzer" <brian_at_selzer-software.com> wrote in message > news:%Vpjk.34162$ZE5.24396_at_nlpi061.nbdc.sbc.com... >
>>"Bob Badour" <bbadour_at_pei.sympatico.ca> wrote in message
>>news:488de63f$0$4041$9a566e8b_at_news.aliant.net...
>>
>>>aarklon_at_gmail.com wrote:
>>>
>>>
>>>>Hi all,
>>>>
>>>>I read the following in a book
>>>>
>>>>1) we can have several non clustered indexes on a table , but we can
>>>>have only one clustered index per table
>>>>
>>>>2) index on the primary key can be clustered or non clustered
>>>>
>>>>now my question is
>>>>
>>>>1) to what extent these statements are true ?
>>>
>>>To the extent the statements accurately describe the physical
>>>implementation of a particular dbms, they are true.
>>>
>>>Theoretically, one can have multiple clustered indexes at the cost of
>>>duplicating the data, which of course incurs a cost. Vendors typically
>>>assUme nobody would ever want to incur that cost.
>>
>>This is bunk. Badour is an idiot. Where there is a clustered index, that
>>index /is/ the table--that is, the table is physically stored using whatever
>>data structure is in use for indexes--probably b-trees.
<snip>
> Though I agree with you,
Do you really agree that a logical construct equates directly to a physical construct? Does that mean you reject data independence entirely?
Or were you agreeing only with his opinion about me?
<snip> Received on Tue Jul 29 2008 - 04:43:58 CEST