Engineering

Presentation on Query Optimization

Presentation on Query Optimization

This lecture focus to Presentation on Query Optimization. Basic discussion are Transformation of Relational Expressions, Catalog Information for Cost Estimation and Statistical Information for Cost Estimation. Here also briefly discuss on Dynamic Programming for Choosing Evaluation Plans. Finally analysis Cost-based optimization and Materialized views.