Home Forums SQL Server 2008 SQL Server Newbies multiple index on same column RE: multiple index on same column
Eirikur Eiriksson
SSC Guru
Points: 182882
More actions
May 3, 2015 at 3:53 am
#1795215
Quick thought, it might be helpful to look at the sys.dm_db_index_usage_stats view.
😎
SELECT
*
FROM sys.dm_db_index_usage_stats IUS
WHERE IUS.object_id = OBJECT_ID(N'[SCHEMA_NAME.TABLE_NAME]');