Auto Update Statistics and FULLSCAN in SQL Server 2008 R2

1.1k Views Asked by At

Is it possible to force FULLSCAN when statistics are updated automatically by SQL Server 2008 R2?

If not, is a planned UPDATE STATISTICS WITH FULLSCAN the best way to keep statistics up-to-date?

note: The need for the FULLSCAN comes by proved suboptimal plan generation when using non-FULLSCAN statistics.

1

There are 1 best solutions below

0
CAFxX On BEST ANSWER

In the end, it looks like it's not possible (see my last comment on the question for details).