Syntax documentationupdate_statistics_statement Locate this document in the navigation structure

Syntax Syntax

  1. <update_statistics_statement> ::=
      UPDATE STAT[ISTICS] COLUMN <table_name>.<column_name>
        [ESTIMATE [<sample_definition>]]
    | UPDATE STAT[ISTICS] COLUMN (<column_name>,...) FOR <table_name>
        [ESTIMATE [<sample_definition>]]
    | UPDATE STAT[ISTICS] COLUMN (*) FOR <table_name>
        [ESTIMATE [<sample_definition>]]
    | UPDATE STAT[ISTICS] <table_name> [ESTIMATE [<sample_definition>]]
    | UPDATE STAT[ISTICS] [<schema_name>.][<identifier>]* [ESTIMATE [<sample_definition>]]
    | UPDATE STAT[ISTICS] AS PER SYSTEM TABLE [ESTIMATE [<sample_definition>]
End of the code.