Optimal query access plans are essential for good query performance and it is the Db2 query optimizer's job to choose the best one. This presentation will cover monitoring and explain facility techniques to help you determine why an access plan is performing poorly and how to correct some common sub-optimal access plan problems.