tiflash mpp semi join use a fixed inner side (idx=1 ref lineitem table here) to be the broadcast table maybe a burden
Open
MPP
sig/planner
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
As you see from tpc-h Q4, the orders table only has 250 lines which is not considered as broadcast side, but the lineitems table with 8000 rows does. Which consequently leads the index join beat the mpp join in the cost side as the end.
Contributor guide
Assessment
This issue has not been assessed yet.