about use ratio and the index useful or useless

  • 892717952

    SSC Veteran

    Points: 237

    1. how to check the use ratio of one index on the table?
    2.  and how to know one index useful or useless? and is there a value of index use ratio to show the index useless?

     

  • Joe Torre

    SSChampion

    Points: 10234

    Research [sys].[dm_db_index_usage_stats]. It has information on usage.

  • 892717952

    SSC Veteran

    Points: 237

    yes, I know there are some information in sys.dm_db_index_usage_stats, but how to evaluate this index is useful or useless based on the information of sys.dm_db_index_usage_stats? and is there any other way to identify to know the index useful or useless

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply