Working with RunTimeStatistics

Derby provides a language-level tool for evaluating the performance and the execution plans of statements, the RUNTIMESTATISTICS attribute.

• Overview of RunTimeStatistics
  When RUNTIMESTATISTICS is turned on for a connection, Derby maintains information about the execution plan for each statement executed within the connection (except for COMMIT) until the attribute is turned off.
• How you use the RUNTIMESTATISTICS attribute
  You can use the RUNTIMESTATISTICS attribute either with or without statistics timing.
• How you use the XPLAIN style
  XPLAIN style is an enhanced form of RUNTIMESTATISTICS processing which preserves captured statistics information in database tables.
• Analyzing the information
  RUNTIMESTATISTICS provides several kinds of information that you can analyze.