Tuning SQL with Optim Query Tuner, Part 1, Understanding access paths

Learn how to monitor and tune queries and workloads to improve application performance

From the developerWorks archives

Gene Fuh, Kendrick Ren, and Kathryn Zeidenstein

Date archived: January 13, 2017 | First published: June 17, 2010

If you are a developer, DBA, or query tuning specialist, it is critical that you understand the basics of access paths so that you can precisely tune queries and query workloads before they cause problems in your production environment. This basic understanding, coupled with the visualization and tuning advice provided by IBM® Optim® query tuning solutions, can help make you more efficient at this task. This article provides conceptual background on access paths, shows you how to read an access path graph, and walks through the access path graph to demonstrate critical information regarding access path selection. The article concludes with a sample scenario that demonstrates how to use query annotation, a feature in Optim Query Tuner that helps you with query analysis by providing vital statistical information directly in the SQL statement.

This content is no longer being updated or maintained. The full article is provided "as is" in a PDF file. Given the rapid evolution of technology, some steps and illustrations may have changed.

Zone=Information Management
ArticleTitle=Tuning SQL with Optim Query Tuner, Part 1: Understanding access paths