drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: Indexes with Included Columns (PG)

Open
#2,972 7 comments 27 reactions 0 assignees View on GitHub
db/postgres drizzle/kit enhancement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Describe what you want

In PG there is a performant options when creating index or unique index. We can include additional data into index data to retrieve some data with index retrieve without more fetch. Example format:
```
CREATE [UNIQUE] INDEX index_name
ON table_name(key_column_list)
INCLUDE(included_column_list);
```
(Contraint cannot be used with Included columns!)

Should I add an PR?

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.