Show TOC

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 (see Server Permission).

  • The database is in the ONLINE operational state.

Procedure

  1. Select the database in the explorer tree.

  2. In the context menu of the database, choose   Administration Tasks   Automatic Statistics Update  .

  3. To deactivate this function, choose Deactivate automatic statistics update.

    To activate this function, choose Activate automatic statistics update.

More Information