v.24.9Experimental Feature
Added experimental min_max statistics for range predicates on numeric columns
Addedmin_maxas a new type of (experimental) statistics. It supports estimating range predicates over numeric columns, e.g.x < 100. #67013 (JackyWoo).
Why it matters
This feature enables efficient estimation of range predicates, such asx < 100, improving query performance and selectivity estimation on numeric data.How to use it
Users can enable themin_max statistics type on numeric columns to utilize range predicate estimation. This is currently experimental and can be applied by configuring table statistics settings accordingly.