help wantedsig/transactiontype/enhancement
倉庫指標
- Star
- (40,090 star)
- PR 合併指標
- (平均合併 14天 4小時) (30 天內合併 346 個 PR)
描述
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.