KScope 2013: win DB Optimizer License at SQL Tuning presentation

June 24th, 2013

SQL Tuning Methodology

   Wednesday, June 26th  Session 13, Bayside C from 11:15 – 12:15 on
   Giving way 2 free copies of DB Optimizer at presentation ($4000 of software)

Horse Racing at Track
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

Delphix: Instant Database Cloning and Changing the Development Paradigm
   Tuesday, Jun 25, 2013, Session 7 ,  9:45 am – 10:45 am
SQL Tuning Methodology
   Wednesday, June 26th  Session 13, Bayside C from 11:15 – 12:15 on





  1. Trackbacks

  2. No trackbacks yet.

  2. No comments yet.
You must be logged in to post a comment.