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? In this hands-on SQLChallenge, you’ll learn how to script out all indexes, group them for analysis, identify duplicate and redundant indexes, and determine which ones can be safely removed. You’ll work through the challenge setup, analyze index structures and usage patterns, and review sample solutions that demonstrate different approaches to index deduplication.

Challenge difficulty

This is designed as a 200 level challenge.