sys.dm_db_index_usage_stats skews results if a filter is placed on the tables

• llewellyn.egerton

  SSC Enthusiast

  Points: 190

  More actions

  March 10, 2019 at 11:32 pm

  #371652

  I was trying to find out when a table was last used using the sys.dm_db_index_usage_stats system table.
  I was trying to clean up unused tables.
  After placing a Filter on the tables in SSMS to view tables with a certain name I discovered that the last_user_scan column is changed to the time I did this.
  As a result, I cannot use sys.dm_db_index_usage_stats to find the information needed.