Add more than 16 columns to clustered index

Question

Is there any way by which i can add more than 16 columns in clustered index.

Answer 1

As of SQLserver 2008 , no. However , I suspect the bottleneck is somewhere else if you require a clustered index on more than 16 columns.

Answer 2

No. further, you are limited to a total of 900 bytes of data for the combined key size.

Quoting from the Create Index reference page.

Up to 16 columns can be combined into a single composite index key. All the columns in a composite index key must be in the same table or view. The maximum allowable size of the combined index values is 900 bytes. For more information about variable type columns in composite indexes, see the Remarks section.