IDUG EMEA has ended
Back To Schedule
Monday, October 24 • 17:00 - 18:00
E09 | Access Paths Meet Coding

Sign up or log in to save this to your schedule, view media, leave feedback and see who's attending!

The ever increasing complexity of DB2 zOS access paths can lead to reduced consideration of them by developers with little time to keep up with all this. Coding and checking to achieve access path goals can, however, be a powerful tool to ensure the performance and quality of the SQL. This session explains our method to deliver this by setting simple rule of thumb goals for our coding and implementing systematic checking.

1. Access paths MIA
2. Simple access path goals
3. Coding to achieve the goals
4. Checking and optimising the access
5. Examples and Summary


Andy Green

Senior Database Designer, Standard Life
Senior Database Designer at Standard Life (part of Phoenix Group). 30years + experience in development database design and administration using DB2 zOS, and also, more recently Oracle. Previous sites include Canon, BHS

Monday October 24, 2022 17:00 - 18:00 BST
3 | Sidlaw Auditorium
  Track E: AppDev & Analytics, Available to Virtual Attendees