Show TOC

Activating or Deactivating the Automatic SQL Optimizer Statistics UpdateLocate this document in the navigation structure

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.

Context

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.

Procedure

  1. Select the database in the explorer tree.
  2. In the context menu of the database, choose Start of the navigation path Administration Tasks Next navigation step Automatic Statistics Update End of the navigation path.
  3. To deactivate this function, choose Deactivate automatic statistics update.

    To activate this function, choose Activate automatic statistics update.

Next Steps