AutoCreateStat Property

SQL-DMO

SQL-DMO

AutoCreateStat Property

The AutoCreateStat property exposes Microsoft® SQL Server™ data distribution statistics creation behavior.

Applies To
DBOption Object
Syntax

object.AutoCreateStat [= value]

Parts

object

Expression that evaluates to an object in the Applies To list

value

TRUE or FALSE

Data Type

Boolean

Modifiable

Read/write

Prototype (C/C++)

HRESULT GetAutoCreateStat(LPBOOL pRetVal);

HRESULT SetAutoCreateStat(BOOL NewValue);

Remarks

If TRUE, the optimizer directs automatic creation of supporting data distribution statistics as required.

If FALSE, the optimizer does not direct statistics creation.