Background documentationauto_update_statistics Locate this document in the navigation structure

 

You can automatically update the SQL Optimizer statistics.

You can activate or deactivate this function in the Database Manager. The default setting is for the function to be deactivated.

You also use this DBM command to display the status of this function.

If the function is activated, the system updates the SQL optimizer statistics (event-controlled) based on the system entries in the SYSUPDSTATWANTED system table.

Note Note

Like other DBM commands, this DBM command requires its own event task. For this reason, make sure when you execute this DBM command that the FloatingServiceTasks and PreservedEventTasks database parameter values are large enough.

Also make sure that the X server is running since the auto_update_statistics function only works if X server is running on the database computer.

End of the note.

Prerequisites

You have the server authorization AccessSQL.

Structure

auto_update_statistics <mode>

<mode> :: = ON | OFF | SHOW

Options

Option

Description

<mode>

Function for automatically updating the statistics of the SQL optimizer. Possible values are:

ON: Enable function

OFF: Disable function

SHOW: Display function

Result

OK

[ON | OFF | UNKNOWN]

Values for the Reply Fields

Value

Description

ON | OFF | UNKNOWN

Output if the SHOW mode is used

ON: the function for automatically updating the statistics of the SQL optimizer is activated.

OFF: the function for automatically updating the statistics of the SQL optimizer is deactivated.

UNKNOWN: the system cannot determine the status of the function for automatically updating the statistics of the SQL optimizer.

In the event of errors, see Reply Format.

More Information

SQL Optimizer, SQL Optimizer Statistics

Database Administration, Analyzing Database Performance