auto_update_statistics

Use

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.

Like other DBM commands, this one requires its own event task. For this reason, make sure when you execute this DBM command that the _MAXEVENTTASKS database parameter value is large enough.

See also:

Concepts of the Database System, Performance

Prerequisites

  •  You have the server authorization AccessSQL.
  •  You have opened a database session (see: db_connect).

Syntax

auto_update_statistics <mode>

<mode> :: = ON | OFF | SHOW

<mode>

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

ON: Enable function

OFF: Disable function

SHOW: Display function

Reply

OK

[ON | OFF | UNKNOWN]

Values for the Reply Fields

Field

Description

ON | OFF | UNKNOWN

Output when using the SHOW mode, possible values are:

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.