pingcap/tidb

TiDB gets row data even using covered index

Open

#37,765 opened on 2022年9月13日

GitHub で見る
 (1 comment) (0 reactions) (0 assignees)Go (6,186 forks)batch import
help wantedsig/transactiontype/enhancement

Repository metrics

Stars
 (40,090 stars)
PR merge metrics
 (平均マージ 14d 4h) (30d で 346 merged PRs)

説明

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.

コントリビューターガイド