Consider filter condition of index access path in skyline pruning
Open
epic/cardinality-estimation
sig/planner
type/enhancement
- Dominant language
- Go
- Stars
- 40.5k
- Forks
- 6.2k
- PR merge metrics
- PR metrics pending
Description
## Enhancement
In current skylinePruning, we don't consider `AccessPath.IndexFilters`. This would results in nonoptimal plan sometimes.
For example, between (1) an index full scan + selection on the index + index lookup and (2) an table full scan + selection, without required order property, current logic would think (2) is better. But in some scenarios this is incorrect.
Contributor guide
Assessment
This issue has not been assessed yet.