QUERY_PLAN_AFTER_RUN option

Function

Prints the entire query plan after query execution is complete.

Allowed values

ON, OFF

Default

OFF

Scope

DBA permissions are not required to set this option. Can be set temporary for an individual connection or for the PUBLIC group. Takes effect immediately.

Description

When QUERY_PLAN_AFTER_RUN is turned ON, the query plan is printed after the query has finished running. This allows the query plan to include additional information, such as the actual number of rows passed on from each node of the query.

For this option to work, the QUERY_PLAN option must be set to ON (the default). You can use this option in conjunction with QUERY_DETAIL to generate additional information in the query plan report.

See also

“QUERY_PLAN_AS_HTML option”

“GRAPHICAL_PLAN function [String]” and “HTML_PLAN function [String]” in Chapter 4, “SQL Functions” in Reference: Building Blocks, Tables, and Procedures