Contents Index TSQL_VARIABLES option [compatibility] USER_ESTIMATES option [database]

ASA Database Administration Guide
  Database Options
    Alphabetical list of options

UPDATE_STATISTICS option [database]


Function 

Controls the gathering of statistics during query execution

Allowed values 

ON, OFF

Default 

ON

Description 

The server collects statistics during normal query execution and uses the gathered statistics to self-tune the column histograms. You can set the UPDATE_STATISTICS option OFF to disable the gathering of statistics during query execution.

The UPDATE_STATISTICS option does not affect changes to statistics as a result of updates to data (LOAD/INSERT/UPDATE/DELETE).

Under normal circumstances it should not be necessary to turn this option off.


Contents Index TSQL_VARIABLES option [compatibility] USER_ESTIMATES option [database]