Query Rewrite: Predicate Pushdown (through grouping)
Example
Query Rewrite: Pushing predicates up
Query Rewrite: Predicate Move-around
Nested Queries
Query Rewrite Summary
Plans for Single-Relation Queries (Prep for Join ordering)
Determining Join Order
Enumeration of Left-Deep Plans
Enumeration of Plans (Contd.)
Cost Estimation
Statistics and Catalogs
Size Estimation and Reduction Factors
Email: alon@cs.washington.edu
Home Page: http://www.cs.washington.edu/homes/alon
Download presentation source