Setting options

Use this step to define basic update statistics options.

Update

All existing statistics

Select this option if you need to update all statistics.

Column statistics only

Use this option to update column statistics only.

Index statistics only

This option indicates that only index statistics will be updated.

Options

Full scan

Specifies that all rows in table or view should be read to gather the statistics. This option provides the same behavior as Sample 100 Percent.

Sample

Specifies the percentage of the table or indexed view, or the number of rows to sample when collecting statistics for larger tables or views.

Resample

Option specifies that statistics will be gathered using an inherited sampling ratio for all existing statistics including indexes. If the sampling ratio results in too few rows being sampled, SQL Server automatically corrects the sampling based on the number of existing rows in the table or view.

No recompute

Disable the option to recompute statistics that become out of date automatically.