Monday, June 14, 2010

Jonathan Lewis / Kyle Hailey Webinar Replay

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:

3 comments:

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

    ReplyDelete
  2. 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

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

    ReplyDelete