Timeline for SQL Server 2000 - How to find unused indexes
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 2, 2014 at 13:13 | comment | added | Kin Shah | Good catch and agreed.. Thanks @aaronbertrand ! I can't imagine any other way to find unused indexes on SQL2000. | |
| Jan 2, 2014 at 0:01 | comment | added | Aaron Bertrand | A trace won't really tell you which indexes are used - you'd have to analyze the execution plans. | |
| Jan 1, 2014 at 17:53 | history | answered | Kin Shah | CC BY-SA 3.0 |