What is the Maximum Number of Index per Table?

9saireddy blogspot
For SQL Server 2005:
1 Clustered Index + 249 Nonclustered Index = 250 Index.
For SQL Server 2008 and 2012:
1 Clustered Index + 999 Nonclustered Index = 1000 Index.

No comments:

Post a Comment

What is Normalization?

Database normalization is a data design and organization process applied to data structures based on rules that help building relational dat...