Fast index traversal - a Db2 12 greatest hit with John Campbell

Fast index traversal is 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. 

Db2 12 can use fast index traversal for many cases starting in function level 100 and full support begins in function level 500. For the whole story, see Fast index traversal - a Db2 12 greatest hit with John Campbell.


Always get the latest news about  Db2 for z/OS from the IBM lab! How to subscribe

Follow us on Twitter: @Db2World and @DB2zLabNews

Views: 85

Add a Comment

You need to be a member of The World of DB2 to add comments!

Join The World of DB2

Bringing Db2 enthusiasts together virtually. Expert or novice, distributed or mainframe, this is the place for everything DB2.

User Groups

Blog Posts

Enhancements to Insert Algorithm 2

Posted by Eric Radzinski on March 13, 2019 at 19:51 0 Comments

Db2 for z/OS APAR PH02052 provides some significant enhancements to Insert Algorithm 2, which was introduced in Db2z 12 to provide faster INSERT throughput for unclustered INSERTs on universal table space objects that use the MEMBER CLUSTER…

Continue

Videos

  • Add Videos
  • View All

DB2 for z/OS APARS

© 2019   Created by Surekha Parekh.   Powered by

Badges  |  Report an Issue  |  Terms of Service