tag:blogger.com,1999:blog-8712796563830044532.post282236921956241666..comments2024-01-26T10:56:10.665+05:30Comments on Knowledge is Here...: Finding UNUSED indexes in oracleGurjeet Singhhttp://www.blogger.com/profile/16619758974707488429noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8712796563830044532.post-69558086772782605162013-01-26T23:05:52.161+05:302013-01-26T23:05:52.161+05:30for sqlserver----------------------
SELECT DISTIN...for sqlserver----------------------<br /><br />SELECT DISTINCT OBJECT_NAME(sis.OBJECT_ID) TableName, si.name AS IndexName, sc.Name AS ColumnName,<br />sic.Index_ID, sis.user_seeks, sis.user_scans, sis.user_lookups, sis.user_updates<br />FROM sys.dm_db_index_usage_stats sis<br />INNER JOIN sys.indexes si ON sis.OBJECT_ID = si.OBJECT_ID AND sis.Index_ID = si.Index_ID<br />INNER JOIN Anonymousnoreply@blogger.com