# 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.

Parent topic: Working with RunTimeStatistics
Related concepts
Overview of RunTimeStatistics
How you use the XPLAIN style
Related tasks
How you use the RUNTIMESTATISTICS attribute