Enable the index join for it whose probe side has a aggregate
Open
sig/planner
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
From the pic, the correlated column propagation can make the table scan as an index scan, while we disable the index join choice for this kind of case.
Workaround: an interesting workaround for this is adding a LIMIT 1000000000 in the probe side above the agg operator, the cost tradeoff may choose the indexRangeScan since LIMIT itself can have a quick close callback.
Contributor guide
Assessment
This issue has not been assessed yet.