Monday, 2 February 2015

How to check disabled Index in database

--How to check disabled index in Database

SELECT
    sys.objects.name,
    sys.indexes.name
FROM sys.indexes
    inner join sys.objects ON sys.objects.object_id = sys.indexes.object_id
WHERE sys.indexes.is_disabled = 1

ORDER BY sys.objects.name, sys.indexes.name

No comments:

Post a Comment