Lecture on Query Optimization

Major purpose of this lecture is to presentation on Query Optimization. Query optimization is a utility of various relational database management systems. The query optimizer attempts to establish the most proficient way to complete a given query by considering the probable query procedure. This lecture briefly focus on Catalog Information for Cost Estimation, Estimation of Statistics, Transformation of Relational Expressions and Dynamic Programming for Choosing Evaluation Plans.