Loading…
Attending this event?
THE BEST IBM i & POWER SYSTEMS EDUCATION.When you come to POWERUp, you’ll be able to customize your experience. Choose from 300 sessions, covering over 20 areas of IT, when you plan your schedule. Visit the largest Expo of its kind and meet the experts behind the solutions. Attend social events to meet renowned speakers and peers alike. This conference is structured to give you the pure education and professional connections needed to best enhance your career. Are you ready to POWERUp?

Exhibitor Hall: https://www.expocad.com/host/fx/common/s24/exfx.html

Exhibitor Hall Map Here 
Back To Schedule
Tuesday, May 21 • 8:00am - 9:00am
180: 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!

Tweet Share
EVALUATION
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 a methodology for identifying and ordering the key definition for new indexes.
Speakers
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 →

Tuesday May 21, 2024 8:00am - 9:00am CDT
Meeting Room 201C 1508 Houston St, Fort Worth, TX 76102
  Database
  • Session Level Beginner
  • Audience Database engineers and performance analysts as well as SQL programmers trying to improve performance

Attendees (32)