The query optimizer and the query execution plans (QEPs) it generates are key to the performance of the RDBMS. But query optimization is often a mysterious process and the choices made by the query optimizer can be difficult to understand. If you've ever wondered how an SQL statement gets optimized and how query execution plans are created, this presentation is for you. Using many QEP examples displayed with the Explain facility, this presentation will cover a variety of optimization topics including query rewrite and cardinality estimation and the cost model.
00:54:55