Prints the entire query plan after query execution is complete.
ON or OFF
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.
OFF
When this option 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.
In order for this option to work, the QUERY_PLAN option must be set to ON (the default). This option can be used in conjunction with QUERY_DETAIL to generate additional information in the query plan report.
