how many columns in a table can i set index in sql server

Posted by Sekar.C under Interview Questions on 2/7/2013 | Points: 10 | Views : 756 | Status : [Member] | Replies : 4
Hi,
how many columns in a table can i set index in sql server?.

Regards
Sekar.c



Responses

Posted by: Santhi on: 2/7/2013 [Member] Starter | Points: 25

Up
0
Down
Hi

what index you need to have?
whether clustered index or non-clustered index

Thanks && Regards,
V. Santhi

Thanks & Regards,
Santhi .V

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

Posted by: Santhi on: 2/7/2013 [Member] Starter | Points: 25

Up
0
Down
Hi


For SQL Server 2005: (For one table)
1 Clustered Index + 249 Nonclustered Index = 250 Index

For SQL Server 2008:(For one table)

1 Clustered Index + 999 Nonclustered Index = 1000 Index

Thanks && Regards,
V. Santhi



Thanks & Regards,
Santhi .V

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

Posted by: Sekar.C on: 2/8/2013 [Member] Starter | Points: 25

Up
0
Down
Hi santhi,
Thank you so much for your response.

Regards
Sekar.c

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

Posted by: Kundan64 on: 2/8/2013 [Member] Starter | Points: 25

Up
0
Down
Hi Sekar,

See the following link: http://www.dotnetfunda.com/interview/exam6487-what-is-the-maximum-number-of-index-per-table.aspx

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

Login to post response