Expand description
Makes your queries faster without changing their meaning.
The optimizer transforms logical plans to run more efficiently:
| Optimization | What it does |
|---|---|
| Filter Pushdown | Moves WHERE clauses closer to scans - filter early, process less |
| Join Reordering | Picks the best order to join tables using the DPccp algorithm |
| Predicate Simplification | Folds 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.