Writing Optimal SQL with Jonathan Lewis April 20, 2009

This tutorial has two targets:

First: how do you improve the performance of a production system by attacking inefficient SQL.
Secondly: how do you design a system so that you can get data into and out of it efficiently. For most people, the design has already happened, nevertheless you need to be aware that the two targets overlap significantly - as you struggle to address a particularly inefficient piece of SQL, you need to be aware that there are structural features of the database that may help you find a cost effective solution despite the problems imposed by the SQL itself.

Official Website: http://cli.gs/agmTuh