Deduplicate Indexes – Level 1 SQLChallenge (56 minutes)

Your challenge

Follow the script to set up a problem in your test instance of SQL Server.

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.


Grab the scripts: