Oct 29, 2019, 09:30 - 13:00

Room: Amsterdam

Presenter: Paul Koufalis - White Star Software, James Palmer - Consultingwerk

Do your indexes need a little love and attention?

If your answer is ""Uhh...maybe?"" then this hands-on DBA workshop is for you. We will explore the various index utilities (idxbuild, idxcompact, idxfix, idxactivate, etc...) and discuss when and how to use each utility to improve query performance or troubleshoot and correct index-related issues.

We will also benchmark the various startup parameters to determine which optimal values should be used under various operating conditions. Overall, expect to walk out of this workshop knowing more than you ever thought possible about indexes and their maintenance.