holistics / holistics/dbml

Define "Included" columns on index for SQL Server

Open
#168 0 comments 0 reactions 0 assignees View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.