ccmdb update_statistics

The ccmdb update_statistics command updates Informix® system tables so that queries execute more quickly.

Synopsis

ccmdb update_statistics database_path [-l|-low]

Uses

Use the ccmdb update_statistics regularly to update Informix system tables so that your queries execute more quickly. This command is run for you as part of the ccmdb check, ccmdb load, and ccmdb unpack commands.

You must be user ccm_root to run this command.

The ccmdb update_statistics command uses the UPDATE STATISTICS statement. Contact IBM® Rational® Software Support for more information about using this command.

Options and arguments

database_path
Specifies the path to the database for which to update the system tables.
-l|-low
Causes the command to perform a quicker, less comprehensive system catalog table check and update. The default is to perform the most comprehensive table check and update, which executes more slowly.

Example

Perform a quick update of the Informix system tables.

$ ccm update_statistics -low


Feedback