|
DB2 ist ein Produkt der
IBM Corporation. Bitte Copyright- und Trademark-Hinweise beachten!
Tune SQL like an expert in DB2 UDB z/OS V8
Number: 7006180 Visibility: Public/Basic (Internet) Published:
June 1, 2005
Component: Performance
Platform(s): z/OS
Version(s): 8
Edition(s):
Publication Number:
Copyright:
URL: http://www.ibm.com/support/docview.wss?uid=swg27006180
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
P.S. Please pass my address to anyone interested in DB2 HOTLINE - thank you.
With kind regards
Michael Dewert, Software Group EMEA DB2 SWAT TEAM MEMBER
© Gernot Ruban