Access Paths and Optimization

If you want to know how a query will be executed by DB2, you must analyze its access path, which is the method for retrieving data from a specific table. The EXPLAIN facility will provide information about how DB2 accesses the data to resolve the SQL statements.

Before describing the capabilities and features of the explain facilities, you should understand at a high level how SQL statements are processed by the DB2 database engine. Each SQL statement is analyzed by DB2, and then it is determined how to process the statement during a static bind or when executed dynamically. The method used to retrieve data from tables is called the access plan.

The component within DB2 that determines the access plan to be used ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.