Category: ‘DB2’

Generating an Explain Plan in DB2 9.7 for LUW

Mar 04 2012

Similar to Oracle’s EXPLAIN PLAN statement and MySQL’s EXPLAIN statement, DB2 provides an EXPLAIN PLAN statement which generates information about the access plan chosen for the specified statement. The information is then placed into explain tables for reference. However, there are times when you simply want to see the explain plan displayed in a hierarchical format with […]