Re: index

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. Received on Mon Jul 28 2008 - 17:31:07 CEST