top of page
Writer's picturekyle Hailey

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)

 

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.

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

   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


headerorange

0 views0 comments

Recent Posts

See All

Comments


bottom of page