Snapshot Level Table Application Statement |
Logical Data Grouping table appl stmt subsection dynsql |
Monitor Switch Table Basic Basic Statement Statement |
Resettable |
Yes |
|
Event Type Connection Table Statement Transaction |
Logical Data Grouping conn_event table_event stmt_event xaction_event |
|
Element Name Element Type |
rows_read counter |
Description: This is the number of rows read from the table.
Usage: This element helps you identify tables with heavy usage for which you may want to create additional indexes. To avoid the maintenance of unnecessary indexes, you may use the SQL EXPLAIN statement, described in the Administration Guide to determine if the package uses an index.
This count is not the number of row that were returned to the calling application. Rather, it is the number of rows that had to be read in order to return the result set. For example, the following statement returns one row to the application, but many rows are read to determine the average salary:
SELECT AVG(SALARY) FROM USERID.EMPLOYEE
This count includes the value in "Accesses to Overflowed Records".