Sample Header Ad - 728x90

Does the Query Optimizer use Incremental Statistics yet?

2 votes
2 answers
455 views
I was considering using incremental statistics in my data warehouse but I read an article by Erin Stellato that says the query optimizer doesn't use incremental statistics. The article was written in May of 2015 but I haven't seen anything recanting her position in the following 6 years. There are a number of articles in different communities that show how to set it up, but if it's not useful, why bother? Does anyone know if subsequent versions of the query optimizer in 2016, 2017, or 2019 support the use of incremental statistics? If not, should we even use them? If they won't help the engine make a good decision about how to query a table with 10 billion records what good is it? Thanx for any help!
Asked by Mike Lemay (57 rep)
Oct 22, 2021, 04:32 PM
Last activity: Jun 8, 2025, 06:49 PM