planner: prevent the optimizer from using different versions of stats of a table during optimization #50281
Labels
component/statistics
epic/cardinality-estimation
the optimizer cardinality estimation
sig/planner
SIG: Planner
type/enhancement
The issue or PR belongs to an enhancement.
Enhancement
In the second query, the optimizer uses 2 versions of statistics of table
t
wherestats-col-a
is loaded and then stats-ver1 is used whilestats-col-b
is not loaded and then pseudo is used, which seems risky.Should we force the optimizer to always use one statistics version of a table during optimization? (all stats-ver1 or all stats-pseudo, no in-between state, not use them together).
The text was updated successfully, but these errors were encountered: