--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