Listing 6

Index range-scan report.

OWNER   TABLE_NAME      INDEX_NAME   TBL_BLOCKS   NBR_SCANS
_____   __________      _________    _________    _________

P00475   TAGS           TAGSIDX3         1,134      153,576
P00475   ENROLL_UPDATE  ENROLL_UPIDX    35,510       39,798
CTS      OBJINDX        OBJINDX_IDX         35       14,858
P00474   DCATS_UPDATE   DCATS_UPIDX    108,500        5,456
CTS      USER_PARAM     USER_PARAM_PK       10        4,580