The DB2Night Show #112: DB2 LUW 10 Index Jump Scans & Index Best Practices


Posted by Scott on June 21, 2013, 12:14 pm
in DB2 LUW ( The DB2Night Show)







Scott Hayes, DBI

Host & Guest: Scott Hayes, DBI Software



DB2 LUW 10 Index Jump Scans and Index Best Practices



100% of our studio audience learned something! During this episode of The DB2Night Show™,
Scott Hayes, IBM DB2 GOLD Consultant and Information Management Champion, wore two hats and doubled as show host and guest! Scott shared an updated edition of his IDUG Orlando presentation on DB2 LUW 10 Jump Scans that adds DB2/AIX tests to the original DB2/Windows tests. Watch and learn...








Scott Hayes, DBI

Host & Guest: Scott Hayes, DBI Software



DB2 LUW 10 Index Jump Scans and Index Best Practices



100% of our studio audience learned something! During this episode of The DB2Night Show™,
Scott Hayes, IBM DB2 GOLD Consultant and Information Management Champion, wore two hats and doubled as show host and guest! Scott shared an updated edition of his IDUG Orlando presentation on DB2 LUW 10 Jump Scans that adds DB2/AIX tests to the original DB2/Windows tests. Watch and learn...










A message from our sponsor:

DBI Software


Today's show was about comparing DB2 9.7 to DB2 10.1, index jump scans in 10.1, and updated index design best practices. During DBI's quick commercial break, we showed how DBI makes it easy to compare database and SQL workload performance between any two timeframes so that you can accurately ascertain the impacts of changes, fix packs, or new releases. Please enjoy this short (2:34) flash video to learn how DBI can help!










Can't see our flash video?
Watch it on href="http://www.youtube.com/watch?v=y9ucDC9VZRE" target="NEW">YouTube.




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.




Show Host Scott Hayes Commentary



I'd like to begin by thanking Martin Hubel, co-host of The DB2Night Show, for saving my bacon (so to speak). When I started the show, I had my screen sharing paused. Fortunately Martin (and attendees) brought this to my attention before we got into the meat of the presentation! So, when you watch the replay, don't panic, the presentation will display correctly!


100% of our studio audience learned something! Terrific! I am now glad and thankful that I stayed up until 3am the night before finishing tests for the presentation! I hope you enjoy the replays!


Upcoming Shows!


Be sure to visit our show schedule and sign up for these upcoming shows!



Episode #111 Survey Winner


Congratulations to Rick Bernstein at CareFusion in San Diego California! Thank you for completing the survey for Episode #111 What's New in DB2 10.5 with George Baklarz, IBM!. You've won a $25 Amazon.com gift certificate! Watch your email!


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! href="http://www.linkedin.com/groupRegistration?gid=2761037" target="NEW" title="New Window: Join The DB2Night Show LinkedIn Group">Join The DB2Night Show LinkedIn Group!



Insider Information


Here's another great reason to join The DB2Night Show LinkedIn Group: SECRET INSIDER INFORMATION. Every once in awhile, we run shows where EVERYONE in our studio audience can be a prize winner! JUST SHOW UP and COLLECT! We only announce these special shows within The DB2Night Show LinkedIn group!


Everyone that attended Episode #110 Database Performance Trends and gave us the prize word SLIPPERS won a $10 gift certificate to Amazon.com, Lowes.com, or Starbucks, or we made donations to the American Red Cross or Big Brothers Big Sisters - at the choice of each show attendee! IT PAYS TO LEARN DB2 on The DB2Night Show!




Get the Download Replays



Remember, as noted above, the screen might start blank initially, but the slides will appear! Just listen in the beginning. Patience!


WMV Format


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


Episode #112, 21 June 2013,
DB2 LUW 10 Index Jump Scans and Index Best Practices with guest Scott Hayes, DBI!


MP4 Format



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




Did you learn something from this show?


See that "Mail this" link below? Click it and do a friend a favor - share this blog post and show with one of your friends or peers. THANKS! icon_biggrin


Share a great show with your friends and followers:


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