Background documentationsql_updatestat_per_systemtable Locate this document in the navigation structure

 

Use this command to update the optimizer statistics of the tables, for which the system determined it was necessary and made an entry in the system table SYSUPDSTATWANTED.

Prerequisites

  • You have the server permission AccessSQL.

  • You have opened a database session (see: db_connect).

Structure

sql_updatestat_per_systemtable

Result

OK

In the event of errors, see Reply Format.

More Information

Concepts of the Database System, SQL Optimizer