What is the maximum number of Index per table in sql 2012?

Question

as compare to the the sql 2005 we create 1 cluster+249 no cluster=250 indexes an in sql 2008 1 cluster+999 non cluster=1000 indexes then  What is the maximum number of Index per table in sql 2012?

Sandeep Mhatre · Answer

yes you have 999 + 1 non clustred and clustered index respctvely the other way to optimize your application is : refer this link: http://sandeepmhatre.blogspot.com/2012/07/optimizing-sql-query.html

Jignesh Trivedi · Answer

hi As per my knowledge is still 1 cluster and 999 non cluster please refer http://msdn.microsoft.com/en-us/library/ms143432.aspx