Updating Statistics

Description

Updates statistical information such as the number of objects, the number of pages to access, and the distribution of attribute values.

Syntax

cubrid optimizedb options database_name

options : [{-n|--class-name=} name]

• cubrid : An integrated utility for the CUBRID service and database management.
• optimizedb : Updates the statistics information, which is used for cost-based query optimization of the database. If the option is specified, only the information of the specified class is updated.
• options : The -n option is supported.
• database_name : The name of the database whose cost-based query optimization statistics are to be updated.

Option

Updating the query statistics of the target database

The following example shows updating the query statistics information of all classes in the database.

cubrid optimizedb testdb

Updating the query statistics of a specific class in the database (-n or --class-name)

The following example shows updating the query statistics information of the given class by using the -n option.

cubrid optimizedb -n event_table testdb