When XPLAIN style is used, the runtime statistics are written to the SYSXPLAIN_* database tables, so that you can analyze the statistics by running queries against the tables.
See "Working with RunTimeStatistics" in
Turn XPLAIN style on by calling this procedure with a non-empty argument. Turn XPLAIN style off by calling the procedure with an empty argument.
The argument that you provide must be a legal schema name, and you should use
this argument to indicate the schema in which runtime statistics should be
captured. If the schema that you specify does not already exist, it will be
automatically created. If the XPLAIN tables do not already exist in this schema,
they will be automatically created. Runtime statistics information about
statements executed in this session will then be captured into these tables,
until runtime statistics capturing is halted either by calling
If authentication and SQL authorization are both enabled, only the
To cause