Topic: DB2 for z/OS
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