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:
Posted by at

3 comments:

  1. UnknownJune 23, 2010 at 3:06 AM

    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. Kyle HaileyJune 23, 2010 at 12:57 PM

    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. Cristian SperantaAugust 13, 2010 at 3:13 PM

    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

Subscribe to: Post Comments (Atom)