Goal:Find out what indexes are being used, if at all, and if the stats on seeks, scans and lookups on the indexes:index-seek (preferred)index-scan (worst)index-lookupSolution... this scrip against your databaseSELECTo.name AS object_name,i.name AS NameOfIndex,i.type_desc as IsItClustered,u.user_seeks as IndexSeeks, u.user_scans as IndexScans,u.user_lookups as IndexLookups, u.user_updates as HowManyUpdates,o.typeFROMsy... iJOINsys.objects o ON i.object_id = o.object_idLEFT JOINsys.dm_db_index_usage_s... ......