we cannot create covering index with clustered

Bandi
Posted by Bandi under Sql Server category on | Points: 40 | Views : 321
CREATE CLUSTERED  INDEX IX_COVERING_CLUSTERED 
ON TableName (PK_Column ) INCLUDE (CoveringColumnName )


gives the error as
"Msg 10601, Level 16, State 1, Line 1
Cannot specify included columns for a clustered index."



NOTE: Be aware of this......

Comments or Responses

Login to post response