AutoUpdateStat Property

SQL-DMO

SQL-DMO

AutoUpdateStat Property

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

Applies To
DBOption Object
Syntax

object.AutoUpdateStat [= 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 GetAutoUpdateStat(LPBOOL pRetVal);

HRESULT SetAutoUpdateStat(BOOL NewValue);

Remarks

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

If FALSE, the optimizer does not direct statistics rebuild.