Relational Query Optimization

10/27/99


Click here to start


Table of Contents

Relational Query Optimization

Overview of Query Optimization

Highlights of System R Optimizer

Motivating Example

Alternative Plan 1 (No Indexes)

Alternative Plan 2 (With Indexes)

Cost Estimation

Statistics and Catalogs

Size Estimation and Reduction Factors

Result Size Estimation (cont’d)

Relational Algebra Equivalences

More Equivalences

Enumeration of Alternative Plans

Queries Over Multiple Relations

Enumeration of Left-Deep Plans

Enumeration of Plans (Contd.)

Example

Summary

State of the Art (partial snapshot)

Email: vandenbe@cs.washington.edu

Home Page: http://www.cs.washington.edu/education/courses/594/99au/

Download presentation source