Update Statistics in IndexOptimize #446
Answered
by
olahallengren
Nehamnsu
asked this question in
Questions & Answers
-
Does the @UpdateStatistics parameter in IndexOptimize update stats with full scan or based on some sampling% on a table? When i checked the CommandLog table for the commands that were run, I didn't see any specification "with Full Scan" |
Beta Was this translation helpful? Give feedback.
Answered by
olahallengren
Nov 24, 2020
Replies: 1 comment
-
@Nehamnsu, by default it is updating the statistics with a default sample. You can use the parameter
|
Beta Was this translation helpful? Give feedback.
0 replies
Answer selected by
Nehamnsu
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
@Nehamnsu, by default it is updating the statistics with a default sample.
You can use the parameter
@StatisticsSample
, if you want to use another sample.https://ola.hallengren.com/sql-server-index-and-statistics-maintenance.html#StatisticsSample
@StatisticsSample = 100
is equal to FULLSCAN.