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.
You have the server authorization AccessSQL.
You have opened a database session (see: db_connect).
sql_updatestat [<table_or_column_spec>]
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) |
SQL Optimizer, SQL Optimizer Statistics