Articles & Content

Archives

How to Achieve Quality in Access Paths (B16)

Topic: DB2 for z/OS

Subtopic: 2011



Access paths are critical in every production environment, therefore ITERGO has implemented a sophisticated procedure to assure the best possible access path based on explain figures. Already in early stages of the program development, the access paths are checked. If they are optimal, they are approved and tagged as qualitiy assured. Otherwise quality assurance methods are applied like creating new indexes or altering existing ones or informing the developper how to improve the statement. This presentation outlines these processes. Also it gives hints and tricks how to improve access paths.



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.