The Explain tables capture access plans when the Explain facility is activated. The following Explain tables and definitions are described in this section:
The Explain tables must be created before Explain can be invoked. To create them, use the sample command line processor input script provided in the EXPLAIN.DDL file located in the 'misc' subdirectory of the 'sqllib' directory. Connect to the database where the Explain tables are required. Then issue the command: db2 -tf EXPLAIN.DDL and the tables will be created. See Table Definitions for Explain Tables for more information.
The population of the Explain tables by the Explain facility will neither activate any triggers nor activate any referential or check constraints. For example, if an insert trigger were defined on the EXPLAIN_INSTANCE table and an eligible statement were explained, the trigger would not be activated.
For more details on the Explain facility, see the Administration Guide.
| Legend for the Explain Tables: |
| Heading | Explanation |
| Column name | Name of the column |
| Data Type | Data type of the column |
| Nullable? |
Yes: Nulls are permitted No: Nulls are not permitted |
| Key? |
PK: Column is part of a primary key FK: Column is part of a foreign key |
| Description | Description of the column |