CODEWITHSUNDEEP
sqlsql-server
user384080
user384080

Reputation: 4692

auto create statistics

I just can't get around my head about AUTO_CREATE_STATISTICS? I run the tuning advisor and it advised me to create statistics on a table. the AUTO_CREATE_STATISTICS is set to true and i would have expected the statistics would have been created automatically. Can anyone please explain?

Upvotes: 5

Views: 1508

Answers (1)

Jim L
Jim L

Reputation: 2327

"The AUTO_CREATE_STATISTICS option does not determine whether statistics get created for indexes. This option also does not generate filtered statistics. It applies strictly to single-column statistics for the full table."

From here... http://msdn.microsoft.com/en-us/library/ms190397.aspx

But I must say, like so many other important parts of documentation, that was buried.

Upvotes: 4

Related Questions