How many clustered index to be created in table in sql server

Posted by Jitendrasoft09 under Sql Server on 6/26/2013 | Points: 10 | Views : 757 | Status : [Member] [MVP] | Replies : 4
Hi All,
I want to understand How many clustered index to be created in table in sql server, let me know if anybody knows.

Jitendra Kumar
If my post helps you, plz mark as an answer.



Responses

Posted by: Satyapriyanayak on: 6/26/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
Table can have only one clustered index.

If this post helps you mark it as answer
Thanks

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

Posted by: Neeraaj.Sharma on: 6/27/2013 [Member] Starter | Points: 25

Up
0
Down
Mark as ans if helps


Question How many clustered index to be created in table in sql server?
Ans Only one
Reason usually table sort physically as well on that column you create clustered index.

Question can we include more than one column in clustered index?
Ans Yes you can maximum 16 column or 900 bytes, but recommend you use as less column and bytes as possible.




visit mu blog
www.tutorialsqlserver.com





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

Posted by: Sriramnandha on: 9/6/2013 [Member] Starter | Points: 25

Up
0
Down
Hi,

Each Table can have only one clustered Index....

More number of NonClustered Index available in sql seve3r


hope this will help



sriram

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

Posted by: Allemahesh on: 9/6/2013 [Member] [MVP] Silver | Points: 25

Up
0
Down
Dear Jitendrasoft,

1. Clustered Index is Only one per table.
2. Faster to read than non clustered as data is physically stored in index order.
3. The primary key created for the column will create a clustered index for that column.

Happy coding

If it helps you or directs U towards the solution, MARK IT AS ANSWER

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

Login to post response