T-SQL - Is there a way to show index_advantage more friendly?

by Rodrigo Nascentes   Last Updated April 06, 2017 22:06 PM

Is there a way to show index_advantage more friendly like 99.54%??

SELECT TOP 25
user_seeks * avg_total_user_cost * (avg_user_impact * 0.01) AS [index_advantage] FROM sys.dm_db_missing_index_group_stats ORDER BY index_advantage DESC;

It shows a number like 41554133.7 so I want to show in percentage e.g. 99.54.



Related Questions


creating index on big table(s)

Updated September 03, 2018 18:06 PM

Linked Server Error on SQL Agent Job

Updated March 16, 2016 08:02 AM