I can observe that user tables without records get StatisticUpdateDate = null, but I have user tables with records that StatisticUpdateDate = null.
And are these tables being updated? It is not uncommon that you have tables with reference data that are loaded once and never changed. Both Ola's script and sp_updatestats will skip tables where the modification count is 0.
You would also see this pattern on staging tables that are truncated, loaded and then indexed and then not touched until next reload. As I recall TRUNCATE TABLE clears all statistics, so you are essentially starting over.
And again the question is: do you have an actual problem with outdated statistics?
Sign in to comment
That is perfectly normal. It just means the stats have not been updated since they were created.
Are you having an issue of some kind?