I find 3 articles about the subject. http://blog.sqlauthority.com/2008/02/11/sql-server-2005-find-unused-indexes-of-current-database/ http://www.databasejournal.com/features/mssql/sql-server-index-t-sql-statements.html Script number 8. and Gred Norman in our site. Not all of them use the same criteria, specially Script number 8. Testing the 3 scripts, sqlauthority and Greg are similar (all indexes are used), but databasejournal suggest to delete a lot on indexes. What do you think?