Auto Update Statistics not triggering on filtered indexes

• Leo.Miller

  SSChampion

  Points: 13072

  More actions

  March 30, 2026 at 4:03 am

  #4757433

  I've got a table with 186,703,969 rows, about 300GB of data. There are several filtered indexes on the table, two among them filter on "Specific_ID IS NOT NULL" - top row in the screen shot, and "Column5 = 'Sum Available' " in row two.

  I've found that for two of the Index Statistics, Auto Update Stats has not triggered, even though the percentage change is high, in one case over 100%, as you can see in the screen shot of the statistics for the two indexes. Note, the filter returns only 187,754 rows for the one index, so a very small percent of the total table rows.

  Is this expected behaviour or a feature?

  

  • This topic was modified 3 hours, 17 minutes ago by Leo.Miller.

  Leo
  Nothing in life is ever so complicated that with a little work it can't be made more complicated.