cockroachdb / cockroachdb/cockroach
sql: consider disallowing `NOT VISIBLE`, `UNIQUE` indexes
Open
C-enhancement
O-support
P-3
T-sql-queries
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
There are limited use cases for `NOT VISIBLE`, `UNIQUE` indexes, primarily because they still need to be read from in some cases to maintain uniqueness and FK constraints. We should consider disallowing them and only allowing non-unique indexes to be `NOT VISIBLE`.
Jira issue: CRDB-44282
Contributor guide
Assessment
This issue has not been assessed yet.