Articles & Content

Archives

[F12] To include or not include? That is the quesstion.

Topic: 2013 EMEA

Subtopic: DB2 for z/OS



DB2 V10 introduced the ability to include non-key columns in a unique index, allowing index only access without affecting the unique key. That's great for the transaction benefiting from index only access, but what about the other transactions that access this index? Can they be negatively affecting?



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.