What is the maximum number of Index per table in sql 2012?
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 MhatrePosted Apr 7, 2013, 1:13 PM
Jignesh TrivediPosted Apr 5, 2013, 7:59 AM
As per my knowledge is still 1 cluster and 999 non cluster
please refer
http://msdn.microsoft.com/en-us/library/ms143432.aspx