Sheryl Larsen SQL Tuning Seminar Now Available

This is the second of three presentations donated to IDUG by Sheryl Larsen. This presentation is from her Tuning SQL for Performance seminar, and contains information about advanced SQL programming and performance.

Description:

This class is all about increasing the attendee’s ability to identify and fix access path problems
Skills Taught:

  • Learn how DB2 executes index, table and join access paths
  • Learn when each access path is optimal and non-optimal
  • Learn recommended SQL tuning techniques for changing the DB2 optimizer’s mind
  • Learn how to identify potential access path problems

There are 112 slides total. Notes are included for many of the slides

http://www.idug.org/p/do/sd/sid=5500&type=0

“I believe Advanced SQL knowledge and skills are so very essential for today's and tomorrow's developers and database professionals. The advancement of SQL knowledge has been my focus for many years and I have a strong commitment and desire to keep it moving forward.  By teaming up with IDUG, I am able to share my Advanced SQL training materials with the world!  To your continued SQL learning! Enjoy!” –Sheryl Larsen

The Content Committee file library can be found here.

http://www.idug.org/p/do/si/topic=428&type=0

 

Recent Stories
Db2 for z/OS locking basics

A Beginners Guide to Locks, Latches, Claims and Drains in DB2 for z/OS by Steve Thomas

Fun with Date Ranges