Articles & Content

Archives

D17 - A Deep Dive into Jump Scan: How Does it Work and What Can it Do

Topic: 2014 EMEA

Subtopic: DB2 for LUW



If you create indexes to speed up queries, this session will show how to improve your query performance even more. It takes a deep dive into the Jump Scan feature available from DB2 v10.1 and explains how indexes are now utilized for a new class of queries that contain gaps. It also explains what Jump Scan can and cannot do. Finally, through an example, it addresses a misconception about logical index I/Os introduced by Jump Scan’s index probes. This example illustrates that Jump Scan reduces both physical index I/Os and query execution time because local index I/Os’ code path is highly optimized for Jump Scan, and their performance impact is typically much smaller than physical index I/Os.



Click Here to Download

NOTE: These are only open to members of IDUG. If you are not a member, please CLICK HERE for more information.