EitanBlumin / EitanBlumin/sp_GenerateTableDDLScript

INCLUDE index columns are being generated as covering index columns

Open
#12 2 comments 0 reactions 1 assignee Claimed by @EitanBlumin View on GitHub
bug
Dominant language
TSQL
Stars
6
Forks
1
PR merge metrics
No merged PRs in 30d

Description

Hello,

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)

Contributor guide

No contributing guide indexed for this repository

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.