Create index considers unnecessary columns
Open
bug
indexes
performance
sql
- Dominant language
- Go
- Stars
- 24.4k
- Forks
- 873
- Avg merge
- 1d 5h
- Merged PRs (30d)
- 108
Description
A customer had a large table that had a `text` column in it. When creating an index it took multiple days because it was round tripping to get the `text` column even though it didn't need it.
```go
for {
k, v, err := iter.Next(ctx)
idxKey, err := secondaryBld.SecondaryKeyFromRow(ctx, k, v)
if err != nil {
return nil, err
}
if err = mut.Put(ctx, idxKey, val.EmptyTuple); err != nil {
return nil, err
}
}
```
We should only fetch the columns we need for the index.
Contributor guide
No contributing guide indexed for this repository
Assessment
This issue has not been assessed yet.