Articles & Content

Archives

The Golden Path: The in's and out's of DB2 LUW Access Plans (D11)

Topic: 2008 NA

Subtopic: DB2 for LUW



DATE: 2008-05-21 (02:45 PM - 03:45 PM)
SPEAKERS: Raj Bahra (Spherion Corp)

Understanding how a query runs is a key component to improving database performance, availability and usability. The DB2 optimizer is a very powerful component of the database engine and understanding its functionaility is an important part of ensuring the success of your implementation.This presentation provides an indepth coverage of the major components of the DB2 LUW optimizer. From the different phases of query compilation including query rewrite, cost optimization, to reviewing access plans using tools delivered within a standard DB2 install. We'll start with an overview of the major phases of optimization and will then jump into some of the query rewrite rules and review access plan operators, how they work, their benefits and challenges. Examples will be provided in an interactive style session to help further solidfy the concepts provided.

EXP. LEVEL: Beginner,Intermediate,Advanced

OBJECTIVES:

An overview of the DB2 query optimization process. This can be used to assist in problem investigation by allowing an attendee to approach query tuning from a functional approach.

An understanding of the various query access operations that are performed during query execution. Additionally their performance benefits and opportunities.

Coverage of several query rewrite rules used to help simplify query logic. This can aid attendee's in any tuning opportunities where manually rewriting the SQL is an available tuning option.

Understanding the three major join operations performed within DB2 (nested loop join, merge sort join, and hash join). A review of their underlying funtionality and performance considerations.

Review of several examples and techniques used to optimize and tune a query for improved performance. Essentially augmenting an attendee's tuning toolbox with additional techniques, practices and information to assist in any tuning opportunities.



This file is being provided by IDUG. We would encourage you to join IDUG to get full access to all of our files and resources. Joining IDUG is FREE and signing up is simple. Click here to join! or login!

Download File
Click to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.