Show TOC

sql_updatestat_per_systemtableLocate this document in the navigation structure

Use

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