SQL 2005 Index Size



Q:  In MS SQL 2000, there is a limitation of maximum length of index key to be 900 bytes. Would this limitation be revised to have it larger than 900 bytes in coming MS SQL 2005 release?


A:  From the SQL 2005 CTP Books Online:  "SQL Server 2005 retains the 900-byte limit for the maximum total size of all index key columns. This excludes nonkey columns that are included in the definition of nonclustered indexes."


Comments (0)

Skip to main content