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.
This class is all about increasing the attendee’s ability to identify and fix access path problems
- 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
“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.