Team with the best
Db2® LUW Performance Tools
company in the World

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

June 21, 2013, 12:14 pm
Posted by Scott in DB2 LUW
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 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!
  • DB2 LUW Customer Success Story - Implementing and Tuning a new application!
    • Want to learn how to get fast index access on "LIKE '%string%'"??? Don't miss this show!
  • Season #5 will kick off on 6 September 2013 at 10am Central with a special 90 minute show discussing DB2 BLU Experiences and Best Practices. Berni Schiefer, Jessica Rockwood, and Michael Kwok from the IBM Canada Lab will be our guests!

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 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! 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,, 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:

Printer friendly