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.