Printer FriendlyEmail Article Link

How do I manually run Update Statistics?

Answer

As pmiowner:

update_db_statistics

The log is located in:

hostname> ls -lrt /hekimian/pmint/log/update_db_statistics.log

The crontab entries for the twice-a-week run and the daily one are:

30 15 * * 0,3 exec >/dev/null 2>&1 && . ./.profile && update_db_statistics
10 * * * * exec >/dev/null 2>&1 && . ./.profile && update_daily_table_statistics.pl


Product : Informix