Post reply

Included Indexes

  • December 18, 2015 at 12:18 am

    #1846700

    Nice question thanks Steve

    ...

  • December 21, 2015 at 2:14 am

    #1847047

    Steve Jones - SSC Editor (12/16/2015)

    #1 is correct.

    If I have a table and do this:

    CREATE CLUSTERED INDEX ix_mybigtable ON dbo.mybigtable (id, largechar) INCLUDE (largechar2)

    I get this:

    Msg 10601, Level 16, State 1, Line 1

    Cannot specify included columns for a clustered index.

    The questions is on included columns. However I can see the phrasing being poor, so I've altered this to say INCLUDE specifically.

    Hi Steve ,

    Thanks for your interesting question and you have got a good point for you : you admitted that you have written your question in an ambiguous way. A proof of your intelligence so CHEERS...

    I can answer only because I have studied this part of indexes last month when I had to create a new database on a SQL Server 2014 instance.

    Have a nice day.

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply