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)
You can’t learn everything in one day. Subscribe the newsletter via E-Mail, Bluesky or RSS to gradually catch up. Have a look at modern-sql.com as well.
About the Author
Markus Winand provides insights into SQL and shows how different systems support it at modern-sql.com. Previously he made use-the-index-luke.com, which is still actively maintained. Markus can be hired as trainer, speaker and consultant via winand.at.
Buy the Book
The essence of SQL tuning in 200 pages
Buy now!
(paperback and/or PDF)
Paperback also available at Amazon.com.
Hire Markus
Markus offers SQL training and consulting for developers working at companies of all sizes.
Learn more »