Fast index traversalis one of the the most important new performance features in Db2 12 for z/OS. It is an in-memory index performance optimization that enables Db2 to do fast index lookup, by avoiding expensive index B-tree traversal.To benefit from fast index traversal, data access must use a random pattern. However, SELECT, INSERT, DELETE and UPDATE statements, and in fact any operation that requires traversal of an index, can benefit from fast index traversal.
Just like a high performance sports car, a database requires some checks to keep it running optimally. This article is broken down into tasks or checks that can be run at different intervals on your DB2 LUW database, to do just that. Read more