Your challenge is to de-duplicate the indexes on a table in a sample database. Can you predict which indexes are the safest ones to drop?
Challenge difficulty
This is designed as a 200 level challenge.
Scripts
Grab the scripts: https://github.com/LitKnd/SQLWorkbooks/tree/main/deduplicating_indexes_sqlchallenge
Lessons
Challenge Setup (5 minutes) |
Scripting Out All the Indexes (15 minutes) |
Grouping the Indexes for Analysis (11 minutes) |
Analysis and Deduplication (22 minutes) |
Summing Up and Looking Ahead (3 minutes) |