KScope 2013: win DB Optimizer License at SQL Tuning presentation
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)
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
Wednesday, June 26th Session 13, Bayside C from 11:15 – 12:15 on
