auto_update_statistics

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