EXPLAIN Explained: Recent Changes That Let Us Use EXPLAIN Better

We use Explain to find out the access path for a new query or when you Bind a package.   Jim Dee, BMC Software's Chief Architect for DB2 for z/OS shows you how you can compare the access path with previous versions of the query or package – comparing the estimated costs, and identifying those that have changed with a rebind due to a new DB2 version, change in statistics or even a change to the code.

Recent releases of DB2 have enhanced the Explain facility and have provided Access Path Stability.  Jim will show you how to take advantage of these features.  His article can be found here

Recent Stories
Some of my favorite tunings tips and tricks for DB2 by Joe Geller

SQL Tuning for Developers – Part 1

The Key To Mastering Db2 Locking On Row-Store Tables