sqlserver2008 查看数据库自带的索引建议
时间：2021-07-01 10:21:17
帮助过：15人阅读
c.name AS databasename,
c.equality_columns,
c.inequality_columns,
c.included_columns,
c.statement AS tablename,
c.avg_total_user_cost AS ReducingTheAverageCost,
c.avg_user_impact AS PercentageOfRevenue,
c.last_user_seek AS TheLastTimeTheEffectAfterUse,
c.unique_compiles
FROM (
SELECT
a.name,
b.*
FROM (
SELECT
d.*,
s.avg_total_user_cost,
s.avg_user_impact,
s.last_user_seek,
s.unique_compiles
FROM sys.dm_db_missing_index_group_stats s,
sys.dm_db_missing_index_groups g,
sys.dm_db_missing_index_details d
WHERE s.group_handle
= g.index_group_handle
AND d.index_handle
= g.index_handle
AND s.avg_user_impact
> 90
--AND s.unique_compiles > 10
--order by s.avg_user_impact desc
) b,
sys.databases a
WHERE a.database_id
= b.database_id) c
WHERE c.name
= ‘xxxxx‘
ORDER BY PercentageOfRevenue
DESC, unique_compiles
DESC
sqlserver2008 查看数据库自带的索引建议
标签：included where rom font percent ota join 数据 order by
