Background documentationsql_updatestat Locate this document in the navigation structure

 

You update the statistics for the SQL Optimizer.

You can update all the statistics or restrict the update function to a set of statistics using a table or column specification.

Prerequisites

  • You have the server authorization AccessSQL.

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

Structure

sql_updatestat [<table_or_column_spec>]

Options

Option

Description

<table_or_column_spec>

Table or column specification

For possible arguments and key words, see: SQL Reference Manual, UPDATE STATISTICS Statement (update_statistics_statement)

Result

OK

In the event of errors, see Reply Format.

More Information

SQL Optimizer, SQL Optimizer Statistics