db-derby-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Apache Wiki <wikidi...@apache.org>
Subject [Db-derby Wiki] Update of "StmtExecutionPlan" by SusanCline
Date Fri, 31 Mar 2006 18:59:23 GMT
Dear Wiki user,

You have subscribed to a wiki page or wiki category on "Db-derby Wiki" for change notification.

The following page has been changed by SusanCline:
http://wiki.apache.org/db-derby/StmtExecutionPlan

------------------------------------------------------------------------------
+ = Interpreting Some Information in the Statement Execution Plan =
+ 
  The RUNTIMESTATISTICS attribute can be used to obtain information about the length
  of the compile time and the execution time for each statement executed within
  a connection and the statement execution plan itself.  The statement execution plan is
@@ -17, +19 @@

  
  Note that this example is using an isolation level of read committed and is using
  row level locking.
- 
+ {{{
  Source result set:
  Index Scan ResultSet for TS_MYTAB using constraint PK_TS_MYTAB at read committed 
  isolation level using instantaneous share row locking chosen by the optimizer
@@ -25, +27 @@

  Rows seen = 1
  Rows filtered = 0
  Fetch Size = 16 
- 
+ }}}
  Two of the parameters being reporting on here, Rows seen and Fetch Size do not relate
  directly to the number of rows locked during the execution of the statement.
  
@@ -40, +42 @@

  
  http://db.apache.org/derby/docs/dev/devguide/rdevconcepts8424.html 
  
+ This page was compiled with information gleaned from Sunitha Kambhampati 
+ and Mike Matrigali.
+ 

Mime
View raw message