Define "Included" columns on index for SQL Server
Open
enhancement
good first issue
help wanted
- Dominant language
- JavaScript
- Stars
- 3.7k
- Forks
- 233
- Avg merge
- 1d 23h
- Merged PRs (30d)
- 4
Description
As a user, I would like the ability to define the `INCLUDES (Col1, Col2)` syntax when defining an index on a table.
Example
`CREATE INDEX IX_NonClusteredIndex1 ON Table1 (Column1) INCLUDES (Column2)`
These indexes are critical for our database, which is enterprise level and including columns in the index saves valuable page reads if the selected values are returned in the index look up.
Contributor guide
Assessment
This issue has not been assessed yet.