Post reply

INDEX UTILIZATION script and determining WHICH INDEXES are NOT USED at all

  • April 20, 2017 at 10:14 am

    #320563

    this is regarding the script from here:
    https://www.sqlservercentral.com/Forums/1870280/Index-Utilization-Summary?Update=1#bm1871960

    Question: if everything (each column) from the resultset of the original index-utilization qry
    if all columns for row columns to the right of has_filter are NULLs -- does it means that the index IS NOT USED AT ALL?
    also, why database id and object id for some rows would be NULL ? table listed in col 1, index name in col 3 of the result-set -- so why db id and obj id would be nulls, really?

    THANK YOU SO MUCH in advance for possible dispersing of my doubts and confusions...

    Likes to play Chess

  • April 20, 2017 at 10:34 am

    #1939136

    No. It means that it hasn't been used since the last time the database was started (last time it was restored, or last time SQL Server started)

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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