How many clustered index can we create in a single table?

Posted by Prabu_Spark under Interview Questions on 2/4/2014 | Points: 10 | Views : 1423 | Status : [Member] | Replies : 3
Hi sir,
How many clustered index can we create in a single table? Kindly give me the solution for this question.

With regards,
J.Prabu.
[Email:prbspark@gmail.com]



Responses

Posted by: Sravan661 on: 2/4/2014 [Member] Bronze | Points: 25

Up
0
Down
Hi,
we can create only one clustered index for a table
fyi if you create a primary key automatically clustered index will be created for that column
Non clustered index can be multiple


for more information on this please see the url
http://www.codeproject.com/Articles/173275/Clustered-and-Non-Clustered-Index-in-SQL-2005

sravan

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sureshij on: 2/4/2014 [Member] Starter | Points: 25

Up
0
Down
Yes we can create ONLY ONE clustered index on a single table. By default Primary key will create clustered index on the primary key columns. If you wish to create non-clustered index on primary key (PK) column you should mention PRIMARY KEY NONCLUSTERED clause while PK creation.

By the way you can create more than one nonclustered indexes on a single table.

ij

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Snaveen on: 2/13/2014 [Member] Starter | Points: 25

Up
0
Down
Hi,

In a table you can able to create only one clustered index.
Similallarly in sql 2005 you can able to create 249 non-clustered indexes and in s1l -2008 you can able to create 999 non- clustered indexes.

Prabu_Spark, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response