Jonathan Lewis / Kyle Hailey Webinar Replay

June 14th, 2010
Goto comments Leave a comment

Thanks to everyone who joined for the webinar with Jonathan Lewis last Thursday. I’ve been getting a number of inquiries asking if the webinar was recorded. The webinar was recorded and you can view it at
http://www.embarcadero.com/master-sql-tuners-oracle-lewis-hailey
Here is a snippet from my part using DB Optimizer

It’s a bit fuzzy on youtube. The real presentation is high quality.
Here is a clear image from DB Optimizer:


Uncategorized

  1. Trackbacks

  2. February 11th, 2012: SQLTXPLAIN quick tips and tricks and DB Optimizer VST « Karl Arao's Blog

  1. Comments

  2. HansP
    June 23rd, 2010 at 10:06 | #1
    Reply | Quote

    Hi Kyle,

    I watch the presentation. Very interesting tool.
    But I have a question.
    Why did you not use the same query as Jonathan did.
    Your query was in ANSI syntax. Was that on purpose?
    Can your tool not handle the Oracle syntax?

    regards Hans-Peter

  3. Kyle Hailey
    June 23rd, 2010 at 19:57 | #2
    Reply | Quote

    Hi Hans-Peter,

    The tool handles either variation, Oracle's ANSI 89 as well as ANSI. I had copied the query directly from a previous presentation by Jonathan here :
    http://www.simple-talk.com/sql/performance/designing-efficient-sql-a-visual-approach/
    Best
    Kyle

  4. Cristian Speranta
    August 13th, 2010 at 22:13 | #3
    Reply | Quote

    This was a great demo and the power of DBO really shone – you can see how much a time saver it is when compared with hunting around the data dictionary for all the various stats and indexes related to the SQL…and of course the VST is killer ! The filter ratio's and join ratio's are so cool I am never going back to "long hand" !

    Great stuff Kyle…

    Cheers ,
    Cristian Speranta

You must be logged in to post a comment.