You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
If the origin table has an index with INCLUDE columns, the output script has those columns as covering columns.
Origin
CREATE INDEX idx1 ON MyTable (Col1) INCLUDE (Col2, Col3)
Output
CREATE INDEX idx1 ON MyTable (Col1, Col2, Col3)
The text was updated successfully, but these errors were encountered:
Rap70r
changed the title
INCLUDE columns are being generated as clustered index
INCLUDE index columns are being generated as covering index columns
May 27, 2020
I used sc.is_included_column column and split the index creation section into 2. First create the index with sc.is_included_column = 0 and second create the INCLUDE section with sc.is_included_column = 1.
Hello,
If the origin table has an index with INCLUDE columns, the output script has those columns as covering columns.
Origin
The text was updated successfully, but these errors were encountered: