sys.sp_createstats

Description

statement to create single-column statistics on columns that aren’t already the first column in a statistics object. Creating single-column statistics increases the number of histograms, which can improve cardinality estimates, query plans, and query performance.

Syntax

AUTO_CREATE_STATISTICS