Fast index traversal

Fast index traversal is a feature of Db2® that can improve overall random index access. You can manage this feature from the Manage Fast Index Traversal (ADB2Z2I) panel.

Viewing memory used for fast index traversal
You can view statistics about the current amount of memory that Db2 uses for fast index traversal.
Setting the rules for fast index traversal
The rules that determine which indexes or index partitions use fast index traversal are set in the Db2 catalog table SYSINDEXCONTROL. To set or change these rules, you must modify rows in this table.
Viewing index traverse counts
You can view the index traverse counts for a specific index or for a specified number of indexes with the highest traverse counts in descending order.

Parent topic: Db2 systems administration

Related information

Fast index traversal (Db2 13 for z/OS)