Data-distribution statistics are a key factor in how the SQL Server Query Optimizer creates query execution plans. This option directs SQL Server to automatically create statistics for any columns for which statistics could be useful. The default for this option is set to ON. To set auto create statistics ON for database_sample
ALTER DATABASE database_sample
SET AUTO_CREATE_STATISTICS ON;
Statisitics_name – A unique name identifying the statistic group.
Table – The table for which you want statistics.
Column [, …n] – The columns in the table on which to create statistics.
FULLSCAN – Tells the create statistics command to scan the whole table when creating the statistics.
Sample number PERCENT – Allows you to specify how much of the table to scan.
Norecompute – Stops SQL Server from automatically updating statistics on this statistics group.