pingcap / pingcap/tidb

TiDB gets row data even using covered index

Open
#37,765 1 comment 0 reactions 0 assignees View on GitHub
help wanted sig/transaction type/enhancement
Dominant language
Go
Stars
40.5k
Forks
6.2k
PR merge metrics
PR metrics pending

Description

## Enhancement
create table t1(id1 int, id2 int, id3 int, PRIMARY KEY(id1), UNIQUE KEY udx_id2 (id2));

SELECT id2 FROM t1 WHERE id2 = 1

The point-get statement above used covered index `udx_id2 `, but TiDB still needs to get the row data. In fact, we should remove this step.

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.