pingcap/tidb

Support to use the outer side of the (Anti) Semi Join to build the hash table

Open

#32,335 建立於 2022年2月14日

在 GitHub 查看
 (9 留言) (4 反應) (1 負責人)Go (6,186 fork)batch import
help wantedsig/plannertype/enhancement

倉庫指標

Star
 (40,090 star)
PR 合併指標
 (平均合併 14天 4小時) (30 天內合併 346 個 PR)

描述

Enhancement

Currently, when TiDB meets a(an) (Anti) Semi join, it would always choose the inner side to build the hash table. When the inner side is extremely large compared with the outer side, our current strategy would cost a lot on building the hash table by the inner side.

So we should support constructing the hash table by the outer side to speed up the execution when the data distribution is like the above case.

It's something the same with supporting constructing hash table by the outer side of the outer join, which is implemented in TiDB.

貢獻者指南