When you click a specific entry in the SQL statement list on the SQL tab in the Top SQL drilldown, a detail pane appears in the lower half of the tab area. This detail identifies the selected SQL statement, lists the full statement text, and provides operational and performance statistics for the statement.
Note: The SQL Statement Archiver captures a sampling of the SQL statements executed. The expected consequence of this sampling process is that the Archiver might not capture every execution. Therefore, statistics for this statement might actually be minimum values. For example, the value for Executions shows the number of executions that the Archiver has observed for the selected statement. The actual number of executions might be higher, but not lower, since the Archiver might not have captured all executions of the statement.
The text box at the top of the detail pane shows the actual text of the SQL statement. Key words appear in blue; literal values appear in red. You can also select and copy this SQL statement text.
The following details identify the SQL statement:
The following statistics provide an execution summary for the SQL statement:
The following are execution statistics collected for the SQL statement: