a clustered index is a special type of index that reorders the way the records in the table are physically stored . therefore the table can have only one clustered index.
Above answer was rated as good by the following members: Akshathanaik
RE: how many records can take clustured index in sql s...
a clustered index is a special type of index that reorders the way the records in the table are physically stored . therefore the table can have only one clustered index.
RE: how many records can take clustured index in sql s...
In Sql Server a table can have only one clustered index . Whenever a primary key is created for a table a clustered index is created internally and that is why we can not create more than one primary key on a single table.
RE: how many records can take clustured index in sql server
Only 1 clustered index per table.Becoz for every DML executed on the table the physical structure is re-written.Also by default SQL Server creates a Clustered Index on the Primary Key field.But you can also get into SQL Server's tools and remove the default Clustered Index creation on the Primary Key and set it on any other unique key in the same table
RE: how many records can take clustured index in sql server
A clustered index is a special type of index that reorders the way records in the table are physically stored. Clustered index is created by default when we create a primary key on a column.Everyone know that primary key is a unique key So we can create one clustered index per table.Clustered index is stored in a serial passion.
1 
0