The new collection settings take effect during the next RunCollect operation involving the selected statistics. For more information, see RunCollect.
Updating Statistics
| What to Update | Values to Specify |
|---|---|
| Single statistics collection | Non-NULL SCOID When specifying a value for SCOID, you need not specify a value for DatabaseName or TableName.
|
| All statistics for a database | Non-NULL DatabaseName |
| All statistics for a table | DatabaseName and TableName |