Snapshot Information Level Table Application |
API Structure(s) sqlm_table sqlm_appl sqlm_stmt sqlm_subsection |
Monitor Group Table Basic Basic Basic |
Resettable |
Yes |
|
Event Information Level Connection Table Statement Transaction |
API Structure(s) sqlm_conn_event sqlm_table_event sqlm_stmt_event sqlm_xaction_event |
|
API Element Name Element Type |
rows_read counter |
Description: This is the number of rows read.
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 Since Connect".
[ Top of Page | Table of Contents | Glossary | Index ]