Improved random index access (FTB)

Db2 12 introduces fast index traversal (sometimes called fast traverse blocks or FTB), which can improve overall random index access, especially for indexes used predominantly for read access.

Fast index traversal provides improved performance for indexes with frequent lookups.

In Db2 12, fast index traversal is available in function level 100. However, during coexistence with Db2 11, no storage is allocated for fast index traversal of group buffer pool dependent indexes.