Articles & Content

Archives

B14 - Partitioning and indexing - query performance considerations

Topic: DB2 for z/OS

Subtopic: 2014



Will this index reduce I/O? When is a partitioned index a PI vs a DPSI? When can I use DPSIs? Knowing the answers to these questions can help identify how to design indexes for improved performance, and choose partitioning columns to balance data maintenance and query performance. This presentation will outline how the DB2 optimizer processes these indexes, and what has been delivered in DB2 11 for z/OS to improve query performance for indexes on partitioned tablespaces.



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.