This appendix explains how to work with execution plans in DB2 LUW. The tools provided by IBM return the execution plan in a pretty awkward format. To get a similar result as for other databases, we introduce our own tool to display execution plans.
Working With Execution Plans in DB2 LUW Express-C
About the Author
Markus Winand teaches efficient SQL—inhouse and online. He minimizes the development time using modern SQL and optimizes the runtime with smart indexing. His book entitled SQL Performance Explained has become standard reading.
Buy his Book on Amazon
The essence of SQL tuning in 200 pages
Buy on Amazon
(paperback only)
Paperback and PDF also available at Markus’ store.
Hire Markus
Markus offers SQL training and consulting for developers working at companies of any size.
Learn more »
A lot changed since SQL-92!