Access Path Data

This section of the Explain report introduces the access path chosen by Db2®.

For details on how to specify EXPLAIN commands refer to the Report Command Reference.

Explain Report - Access Path Data Block

The following example shows that the access path is contained in a frame.

THE ACCESS PATH CHOSEN BY DB2 AT 18:50:11.7   ON 2016-02-15
+------------------------------------------------------------------+
| MATCHING INDEX SCAN WITH SCAN OF REFERENCED DATA PAGES           |
| NUMBER OF MATCHING COLUMNS: 1 - THE INDEX HAS 4 COLUMNS          |
| NON-CLUSTERED INDEX SCAN WILL BE USED                            |
| OPTIMIZER EXPECTS DYNAMIC PREFETCH                               |
| PAGE RANGE SCAN WILL NOT BE USED                                 |
+------------------------------------------------------------------+