
7.3 Tools for Tuning Queries 211
Chapter 7
into the buffer. Let’s drill down. In Figure 7.26, I drill down into Top
Objects and Top SQL. These two drill downs tell me a lot:
The CASHBOOK table is at the top of both database objects and
SQL in terms of data reads.
The number of executions for the top SQL statement is relatively
low.
The physical reads for the CASHBOOK table are double compared
to the next object down on the list, the ORDERS table primary key
index.
The really obvious part is that the CASHBOOK table is shown as
being heavily active. An index on the CASHBOOK table is not being
used.
Examining Figure 7.26 a little further, do I know what ...