Post reply

Usage stats of an index with included columns

  • August 2, 2016 at 1:09 pm

    #328538

    We have an index with included columns.

    user_lookups column in sys.dm_db_index_usage_stats consistently shows 0. User seeks, scans and updates >0. Does that mean that included columns are not used in this index? Is it safe to recreate this index without include clause?

    Thanks

  • August 2, 2016 at 1:43 pm

    #1893350

    No it doesn't.

    Lookups are the number of key lookups done to that index, and it will only every be >0 on clustered indexes.

    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