Analyzing the information

RUNTIMESTATISTICS provides several kinds of information that you can analyze.

• Statistics timing
  If you are using statistics timing, RUNTIMESTATISTICS provides information about how long each stage of the statement took.
• Statement execution plan
  RUNTIMESTATISTICS also provides information about the statement execution plan.
• Optimizer estimates
  RUNTIMESTATISTICS shows the optimizer estimates for a particular node. It shows the optimizer's estimated row count and the optimizer's "estimated cost."
• Optimizer overrides
  RUNTIMESTATISTICS provides information about user-specified optimizer hints that were specified by using a --DERBY-PROPERTIES clause.
• Understanding XPLAIN style database tables
  XPLAIN style is an enhanced form of RUNTIMESTATISTICS processing which preserves captured statistics information in database tables. Once the statistics have been collected and saved in the tables, they can be queried for analysis purposes.