cockroachdb / cockroachdb/cockroach
sql: hash shard indexes with computed columns
Open
A-hash-sharding
C-enhancement
P-2
T-sql-foundations
- Dominant language
- Go
- Stars
- 32.5k
- Forks
- 4.1k
- PR merge metrics
- PR metrics pending
Description
Users would like to create indexes that reference computed columns to speed up queries. Sometimes, those indexes can lead to hot ranges / hot nodes. Hash Sharding is a technique to avoid hot ranges, but CockroachDB does not currently support hash-sharding an index with computed columns.
The desired solution is to allow hash sharding of an index that contains computed columns.
Jira issue: CRDB-57556
Epic CRDB-60871
Contributor guide
Assessment
This issue has not been assessed yet.