Showing posts with label Clustered Index. Show all posts
Showing posts with label Clustered Index. Show all posts

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