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 : 1793 | Status : [Member] | Replies : 3

Write New Post |

Search Forums | Answered

Resolved Posts |

Un Answered Posts |

Forums Home

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]

Reply | Reply with Attachment

Alert Moderator

Responses

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

0	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

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

0	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

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.

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

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

0	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

Latest Posts