Background documentationsql_updatestat Locate this document in the navigation structure

 

Use this command to 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 permission 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