drizzle-team / drizzle-team/drizzle-orm
[FEATURE]: Indexes with Included Columns (PG)
Open
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
Assessment
This issue has not been assessed yet.