SQL - A Little Knowledge is a Dangerous Thing

Objectives:
To firstly look at the real business reasons behind why we tune and why a little knowledge can be a dangerous thing when it comes to SQL. The bulk of the presentation will concentrate on illustrating how SQL can be ‘tweaked’ to produce better performance at a cheaper cost.

Outline:
Why do we tune?
What are the benefits?
Tuning SQL
Tips, techniques and pointers

Full Abstract:
Get more from your SQL, this section will cover how to tune your statements to provide the best return with the least resources. It’s often easy to get SQL to return the data you are looking for...but could you be doing it better?