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.
The group of DBM commands that uses the built-in event dispatcher requires its own event task. For this reason, make sure when you switch on this function that the FloatingServiceTasks and PreservedEventTasks database parameter values are large enough.
Also make sure that the X server keeps running since the auto_update_statistics function only works if X server is running on the database computer.
You have the server permission AccessSQL and EvtDispMgm.
auto_update_statistics <mode>
<mode> :: = ON | OFF | SHOW
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 status |
OK
[ON | OFF | UNKNOWN]
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.
SQL Optimizer, SQL Optimizer Statistics
Database Administration, Analyzing Database Performance
SAP Note 927882