Static EXPLAIN

Static EXPLAIN data is requested when an “EX” command is issued on a SQL statement, if the DB2X data extractor was selected for the observation request and the SQL statement was bound with the EXPLAIN(YES) option.

Static EXPLAIN data is obtained at the time of the measurement. Any changes made to the DB2® objects since the measurement was requested will not be reflected in the EXPLAIN request.