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.
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.