Writing Optimal SQL with Jonathan Lewis February 7, 2010

This course has two targets:

* First: improving the performance of a production system by attacking inefficient SQL.

* Second: designing a system so that you can get data into and out of it efficiently.

The course will focus on the SQL - falling back to structural issues only as an aid to improving the mechanical efficiency of the SQL solution - but we will spend some time explaining the pros and cons of various structural options as they become relevant to the SQL. The course will cover methods of reviewing data distribution patterns, use of indexes, use of views (stored and inline), analytic functions, sub-query factoring, as well as statistics, hints, and a brief review of execution plans.