How many records can take clustured index in sql server

Editorial / Best Answer

vvijaychandra  

  • Jun 22nd, 2006


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.

Showing Answers 1 - 3 of 3 Answers

Lakshmi Narang

  • Apr 28th, 2006
 

THERE CAN BE AT THE MOST 1 CLUSTERED INDEX FOR ONE TABLE IN SQL SERVER

  Was this answer useful?  Yes

vvijaychandra

  • Jun 22nd, 2006
 

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.

pradeep

  • Jul 31st, 2006
 

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.

  Was this answer useful?  Yes

shashi kant pathak

  • Jun 1st, 2007
 

unlimited.

  Was this answer useful?  Yes

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

  Was this answer useful?  Yes

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.

  Was this answer useful?  Yes

Pendurti

  • Sep 14th, 2008
 

FYI..

Clustered index is something that deals with the columns but not the records.
These define the physical sorting of the rows in the database in the storage media.
A database table can have utmost one clustered index. 
If we do not create a clustered index, SQL server creates a clustered index on the column with primary key. 

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions