The DB2Night Show #52: Writing Optimized DB2 LUW SQL Queries


Posted by Scott on May 13, 2011, 4:11 pm
in DB2 LUW ( The DB2Night Show)

Brilliant! Very Helpful! Outstanding! Participants in the studio audience of Episode #52 gave this show EXCEPTIONAL ratings! Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab. John offered a buffet of outstanding advice on how to get your SQL to run faster and more efficiently! And, John should know the secrets - he IS the mastermind behind the DB2 LUW Optimizer! Watch the replay and take advantage of all John's advice!!!
Brilliant! Very Helpful! Outstanding! Participants in the studio audience of Episode #52 gave this show EXCEPTIONAL ratings! Our special guest was John Hornibrook, STSM, Manager, Query Optimization Development, from the IBM Canada Lab. John offered a buffet of outstanding advice on how to get your SQL to run faster and more efficiently! And, John should know the secrets - he IS the mastermind behind the DB2 LUW Optimizer! Watch the replay and take advantage of all John's advice!!!

Host Commentary


I predict Episode #52 will be amongst the Top 10 most highly downloaded shows for 2011! If you only have time to watch a few episodes, make sure this one is on your short list!


Get the Download Replay



To download a recorded replay of Episode #52, right click on the link below and choose "Save As..."

Episode 52, 13 May 2011, Writing and Tuning Queries for Optimal Performance with John Hornibrook, IBM.


We asked our studio audience what other video formats they'd like to be able to download. MP4 for the Apple iPod and iPhone was a very popular choice, so, as an experiment, we are also making this show available as an M4V file. Get it here: M4V (appx 89MB) . Please don't watch the replay while you are driving! icon_wink


Have an iLife, iDevice, iPod, iPad, or iPhone? Right click and download the M4V ( MP4 ) format!



Join The DB2Night Show™ LinkedIn Group


The DB2Night Show™ has a LinkedIn Group. The "closed" group is open to any LinkedIn member. Join to receive LinkedIn group updates including future shows and replay information, and, if you like, start some discussions about the show! Join The DB2Night Show LinkedIn Group!



A message from today's show sponsor



Do you ever upgrade DB2? Apply fixpacks? Update your applications? Ever wonder about the performance consequences of these changes? What's better? What's worse? By how much?


During today's quick commercial break, DBI demonstrated how you can now easily compare database and SQL workload performance, for two different time windows, in as few as two mouse clicks!!! DBI's Brother-Panther® can vividly show you the performance differences between any two different time periods.


If you seek answers to these questions, DBI has a solution! Don't settle for OEM "free" tools from your database vendor - this is part of a conspiracy to make sure you buy more hardware than you need! In fact, DBI offers a long list of competitive advantages: DB2 LUW Performance Tools Comparison



Our #1 Job is helping you look great!

Our #2 Job is giving you the documentation to prove it!


Contact DBI and find out how our DB2 LUW Performance Solutions can truly help you optimize performance and lower IT costs.


References and Links



Just to give you a sample of some of the incredible content in this presentation (we don't usually do this), we are sharing 11 of 59 slides from John's slide deck via PDF: Download Sample Slides


REMEMBER to REGISTER for upcoming shows! www.DB2NightShow.com icon_cool

Post from : http://www.dbisoftware.com/blog/db2nightshow.php
Printed from : http://www.dbisoftware.com/blog/db2nightshow.php?id=268