Compute Stats Command
The compute stats (pcm_compute_stats.pl) command executes an Oracle program to analyze and compute statistics on each table in the specified Contenta database.
The program stores statistical information for the purpose of optimizing queries (sql) made to the specified Contenta database.
Users cannot be accessing the Contenta database when this program is executed.
The Oracle sql (command) that is executed when you execute pcm_compute_stats.pl is:
analyze table tablename compute statistics
SDL recommends that you refer to your Oracle documentation about the analyze command for detailed information before using the pcm_compute_stats.pl command.