top of page
  • Writer's picturekyle Hailey

KScope 2013: win DB Optimizer License at SQL Tuning presentation

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

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.

  1. DB Optimizer’s Visual SQL Tuning

  2. Jonathan Lewis writes about Visual SQL Tuning 

  3. 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


headerorange

0 views0 comments
bottom of page