Wednesday, 16 July 2014

Maximum number of Index per table.



In SQL Server 2005: 250 Index

                                   Clustered Index: 1
                                   Non clustered Index: 249

In SQL Server 2008: 1000 Index

                                  Clustered Index: 1
                                  Non clustered Index: 999

No comments:

Post a Comment