O'Reilly logo
  • Klaus Nji thinks this is interesting:

An index can have many intermediate levels, depending on the number of rows in the table, index type, and index key width. The maximum number of columns in an index is 16; the maximum width of an index row is 900 bytes.


Cover of Microsoft® SQL Server 2012 Unleashed


Index complexity based on key width