Query Optimization
Warning
SingleStore 9.0 gives you the opportunity to preview, evaluate, and provide feedback on new and upcoming features prior to their general availability. In the interim, SingleStore 8.9 is recommended for production workloads, which can later be upgraded to SingleStore 9.0.
-
Column statistics are now automatically gathered on rowstore tables.
This is in addition to column statistics being automatically gathered on columnstore tables, which was done previously. -
Range statistics (histograms) are now automatically gathered on columnstore and rowstore tables.
-
Rowstore table sampling has been improved.
-
Now, a true row-level random sample of rows from columnstore tables is maintained automatically and used to estimate the selectivity of complex predicates.
-
All shapes of bushy joins are now supported.
-
Common Table Expressions (CTEs) can now be materialized; redundant expressions can use cached data instead of being recomputed.
Last modified: February 22, 2023