pingcap / pingcap/tidb

Consider filter condition of index access path in skyline pruning

Open
#37,689 1 comment 0 reactions 2 assignees Claimed by @hawkingrei View on GitHub
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

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.