http://www-1.ibm.com/support/docview.wss?rs=64&context=SSEPEK&q1=new2005&uid=swg27006187&loc=en_US&cs=utf-8&lang=en

Tune SQL like an expert in DB2 UDB z/OS V8  Product documentation

Abstract
Ever wondered why the DB2® optimizer chooses a certain access path? Before
DB2 UDB Version 8, you had to be an optimizer expert to answer that question. This presentation outlines a method to utilize the extensive access path detail available with Version 8 Visual Explain and compare with the actual reality for a given query. The end result is that you will be able tune SQL like an expert.


Content
Terry Purcell, IBM® Silicon Valley Lab
Tune SQL like an expert in DB2 UDB z/OS V8

(C) Copyright IBM Corp. 2005. All Rights Reserved. US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.

All information available on/through this Web site is provided for the convenience of our customers and without warranty of any kind, including any warranty as to the accuracy of the information contained therein. Use of copyrighted materials for other than your own personal use is expressly prohibited without the written notice of the copyright owner.

P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.

With kind regards
Michael Dewert, Software Group
DB2 Information Management Software