The largest IBM i-related conference event in the world, bringing together the community of users, IBM, industry experts and solution providers.
Back To Schedule
Thursday, April 27 • 8:00am - 9:00am
201: Revving up SQL Performance with Indexes

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

One of the most important things needed to improve SQL performance is to have the proper indexing over tables, especially as table grow in size. Indexes are so important that the database provides index advice for assistance. However, advice is no substitute for knowledge and proper understanding of indexes. As with all advice, it must be reviewed and good judgment applied on when to create them. Learning Objectives: 1. Learn about the importance of indexes on SQL performance
2. Learn how to use ACS tools to process Db2 Index Advice
3. Learn how to use ACS tooling to evaluate which indexes are providing value and which indexes are candidates to delete

avatar for Kent Milligan

Kent Milligan

Senior Db2 for i Consultant, IBM
Kent Milligan is a Senior Db2 for i Consultant in IBM Technology Expert Labs. Kent has over 25 years of experience as a Db2 for IBM i consultant and developer working out of the IBM Rochester lab. Prior to re-joining the Db2 for i Expert Labs practice in 2020, Kent spent 5 years... Read More →

Thursday April 27, 2023 8:00am - 9:00am MDT
Governors Square 14