Home Forums Article Discussions Article Discussions by Author Discuss content posted by rfr.ferrari Nonclustered Indexes RE: Nonclustered Indexes

  • December 7, 2010 at 12:28 am

    #1259402

    ziangij (12/6/2010)

    Is the same number (16) applicable for a clustered index in SQL Server 2008 ?

    Checked the link, could not find if the above number is different in case of clustered index. Please comment. thanks 🙂

    Yes it is.

    If you check "CREATE INDEX (Transact-SQL)" in BOL, it mentions that: " 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."

    Thanks