在DMV sys.dm_db_missing_index_group_stats中,有一个名为avg_user_impact的字段.按照BOL,这显示了
Average percentage benefit that user queries could experience if this missing index group was implemented. The value means that the query cost would on average drop by this percentage if this missing index group was implemented.
当我运行查询以查找对性能影响最大的缺失索引时,我看到一些声称avg_user_impact将在数千个中.
我使用其中一个建议构建了一个索引,并且从未根据DMV sys.dm_db_index_usage_stats使用它.一旦我禁用了索引,它立即再次显示为缺失索引.
一旦avg_user_impact字段显示超过100,它是否可能出错？或者这是一个如何仍然必须测试推荐索引的实例的例子？我做错了什么或误会了？
