Is it possible to alter an existing non clustered index to include more columns as a part of Covered columns.
e.g.
ALTER INDEX IX_NC_TableName_ColumnName
FOR TableName(ColumnName)
INCLUDE(Col1, Col2, Col3)
Want to include Col4
in above index.
What will be the impact of adding this column? Will there be fragmentation or anything else?