查询SQL Server索引上次重建时间
-
查询SQL Server Index上次Rebuild时间的方法
要查询SQL Server Index上次Rebuild时间,可以使用以下SQL语句:,,``sql,SELECT OBJECT_NAME(s.[object_id]) AS TableName, i.name AS IndexName, MAX(i.modify_date) AS LastRebuildDate,FROM sys.dm_db_index_usage_stats AS s,JOIN sys.indexes AS i ON s.[object_id] = i.[object_id] AND s.index_id = i.index_id,WHERE OBJECTPROPERTY(s.[object_id], 'IsUserTable') = 1,GROUP BY OBJECT_NAME(s.[object_id]), i.name,ORDER BY TableName, IndexName;,``