Procedure documentationActivating or Deactivating the Automatic SQL Optimizer Statistics Update Locate this document in the navigation structure

 

The database system needs the SQL Optimizer statistics to determine the optimal search strategy for accessing data when executing complex SQL statements.

When you activate the automatic statistics update, the system updates the SQL Optimizer statistics for all tables whenever necessary.

Prerequisites

  • You are logged on to the database as database system administrator or as a DBM operator with server authorization for accessing an SQL session.

    More information: Glossary, Server Permission

  • The database is in the ONLINE operational state.

Procedure

  1. In the context menu of the database, choose Administration.

  2. Open the Overview tab page.

  3. To activate the automatic update, choose Activate automatic statistics update.

    To deactivate the automatic update, choose Deactivate automatic statistics update.

More Information