Open Source RDBMS - Seamless, Scalable, Stable and Free

한국어 | Login |Register

Versions available for this page: CUBRID 8.3.0 |  CUBRID 8.3.1 |  CUBRID 8.4.0 |  CUBRID 8.4.1 |  CUBRID 8.4.3 |  CUBRID 9.0.0 | 

Updating Statistics

Description

With the UPDATE STATISTICS ON statement, you can generate internal statistics used by the query processor. Such statistics allow the database system to perform query optimization more efficiently.

Syntax

UPDATE STATISTICS ON { table_spec [ {, table_spec } ] | ALL CLASSES | CATALOG CLASSES } [ ; ]

table_spec :

single_table_spec

( single_table_spec [ {, single_table_spec } ] )

single_table_spec :

[ ONLY ] table_name

| ALL table_name [ ( EXCEPT table_name ) ]

  • ALL CLASSES: If the ALL CLASSES keyword is specified, the statistics on all the tables existing in the database are updated.