当前位置:Gxlcms > mysql > 查询从未使用的索引

查询从未使用的索引

时间:2021-07-01 10:21:17 帮助过:32人阅读

查询从未使用的索引 无 select object_name(object_id),* sys.dm_db_index_usage_state where user_seeks=0 and user_scans=0 and user_lookups=0 and system_seeks=0 and system_scans=0 and system_lookups=0 and object_name(object_id) is not null

查询从未使用的索引
<无>
select object_name(object_id),* sys.dm_db_index_usage_state where user_seeks=0 and user_scans=0 and user_lookups=0 and system_seeks=0 and system_scans=0 and system_lookups=0 and object_name(object_id) is not null

人气教程排行