Background documentationauto_update_statistics Locate this document in the navigation structure

 

You can automatically update the SQL Optimizer statistics.

You can switch this function on or off. The default setting is OFF.

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

If the function is ON, the system updates the SQL optimizer statistics based on the entries made by the system in the SYSUPDSTATWANTED system table. The update is triggered by respective database events.

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.

Make sure that X server keeps running while this function is active.

End of the note.

Prerequisites

You have the server permission AccessSQL and EvtDispMgm.

Structure

auto_update_statistics <mode>

<mode> :: = ON | OFF | SHOW

Options

Option

Description

<mode>

Function for automatically updating the statistics of the SQL optimizerPossible 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 inactive.

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