Buffer Pool Index Logical Reads

 
Snapshot Level
Database
Table Space
 
Application

 
Logical Data Grouping
dbase
tablespace
bp_info
appl

 
Monitor Switch
Buffer Pool
Buffer Pool
Buffer Pool
Buffer Pool

Resettable

Yes

Event Type
Database
Table Space
Connection

Logical Data Grouping
db_event
tablespace_event
conn_event

Element Name
Element Type

pool_index_l_reads
counter

Description:  Indicates the number of logical read requests for index pages that have gone through the buffer pool.

Usage:  This count includes accesses to index pages that are:

• Already in the buffer pool when the database manager needs to process the page
• Read into the buffer pool before the database manager can process the page.

In conjunction with "Buffer Pool Index Physical Reads", you can calculate the index page hit ratio for the buffer pool using one of the following:

 
 1 - (buffer pool index physical reads / buffer pool index logical reads)

To calculate the overall buffer pool hit ratio, see "Buffer Pool Data Logical Reads".

If the hit ratio is low, increasing the number of buffer pool pages may improve performance. See the Administration Guide for more information about buffer pool size.