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
Modern indexes for modern data

Bring Intelligence to Where Critical Transactions Run – An Update from Machine Learning for z/OS

SQL Sparse Indexing for Db2 z/OS