Search code examples
sql-servert-sqlsql-server-2008-r2table-statistics

Auto Update Statistics and FULLSCAN in SQL Server 2008 R2


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.


Solution

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