Back To Schedule
Thursday, October 7 • 1:30pm - 2:30pm
Revving up SQL Performance with Indexes

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_x000D_ 2. Learn how to use ACS tools to process Db2 Index Advice _x000D_ 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 the IBM Lab Services Power Systems Delivery Practice.  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 Lab Services practice... Read More →

Thursday October 7, 2021 1:30pm - 2:30pm CDT
Breakout 4 Online

Attendees (1)