Friday, 17 October 2008

Index Usage in current db

Use this to review index usage >

SELECT object_name(object_id), *
FROM sys.dm_db_index_usage_stats
WHERE object_id > 100
AND database_id = db_id()

No comments: