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 on Partitioning Tables

You can update statistics on the database by using the cubrid optimizedb utility or the SQL statement called UPDATE STATISTICS ON CLASSES. You can also use the ANALYZE PARTITION statement for partitioned tables.

The following is an example of the ANALYZE PARTITION statement.

ALTER TABLE t1 ANALYZE PARTITION p3;