Following is a breakdown of the maximum number of indexes by different versions of SQL Server. I am yet to come across a scenario when a table needed to have huge number of indexes like mentioned in the listing below.
| Maximum Sizes | ||||
| Object | SQL Server 7.0 | SQL Server 2000 | SQL Server 2005 | SQL Server 2008 |
| Clustered Index | 1 | 1 | 1 | 1 |
| Non-clustered Index | 249 | 249 | 249 | 999 |
References:
Following is a breakdown of the maximum number of indexes by different versions of SQL Server. I am yet to come across a scenario when a table needed to have huge number of indexes like mentioned in the listing below.
| Maximum Sizes | ||||
| Object | SQL Server 7.0 | SQL Server 2000 | SQL Server 2005 | SQL Server 2008 |
| Clustered Index | 1 | 1 | 1 | 1 |
| Non-clustered Index | 249 | 249 | 249 | 999 |
References:
0 comments:
Post a Comment