SQL Tuning Methodology

---

On Wednesday 11:15  at ODTUG aka KSCOPE 2013 in New Orleans I’ll be giving away 2 copies of Embarcadero’s DB Optimizer which automates SQL tuning analysis as presented in the book SQL Tuning by Dan Tow.

Dan Tow has developed  a step by step methodology to find an optimal execution plan for a SQL query.

The core of Dan’s SQL tuning methodology is based on a visual approach. The visual approach lays out the SQL query in a directed graph where direction is based on the parent child relation between tables. Given the directed graph layout and knowing which tables have predicate filters one can  quickly find the efficient paths that can be used to execute the query. One can solidify the analysis with information about the percent of rows return on tables with predicate filters and the join cardinalities between tables in the query. Embaradero’s DB Optimizer does all of this analysis automatically.

• DB Optimizer’s Visual SQL Tuning
• Jonathan Lewis writes about Visual SQL Tuning 
• Craig Martin’s presentation on how to use Dan Tow’s method 

On Wednesday at Kscope I’ll be giving a modified version of these slides on slideshare.

I’ll also be talking about database thin cloning on database thin cloning and database virtualization

 

 

Kyle Hailey
Uncategorized