Skip to main content

Module optimizer

Module optimizer 

Source
Expand description

Makes your queries faster without changing their meaning.

The optimizer transforms logical plans to run more efficiently:

OptimizationWhat it does
Filter PushdownMoves WHERE clauses closer to scans - filter early, process less
Join ReorderingPicks the best order to join tables using the DPccp algorithm
Predicate SimplificationFolds constants like 1 + 1 into 2

The optimizer uses CostModel and CardinalityEstimator to predict how expensive different plans are, then picks the cheapest.

Re-exports§

pub use cardinality::CardinalityEstimator;
pub use cardinality::ColumnStats;
pub use cardinality::TableStats;
pub use cost::Cost;
pub use cost::CostModel;
pub use join_order::BitSet;
pub use join_order::DPccp;
pub use join_order::JoinGraph;
pub use join_order::JoinGraphBuilder;
pub use join_order::JoinPlan;

Modules§

cardinality
Cardinality estimation for query optimization.
cost
Cost model for query optimization.
join_order
DPccp (Dynamic Programming with connected complement pairs) join ordering.

Structs§

Optimizer
Transforms logical plans for faster execution.