As the number of customers at any given moment is not static, we may want to update the list of customer cities periodically, possibly weekly or monthly, so that the list stays up-to-date.
因为在任何给定的时刻客户的数量都不是静态的,所以我们希望定期更新客户城市的列表,比如每周一次或每月一次,从而保证这个列表反映最新情况。
The objective is to allow DB2 to determine which statistics are required by the workload, and automatically run the RUNSTATS utility in the background periodically to update statistics as needed.
其目标是允许 DB2 确定工作负载需要哪些统计信息,并定期在后台自动运行 RUNSTATS 实用程序,以便按需更新统计信息。
This example shows why UPDATE STATISTICS has to be run periodically.
这个例子表明为什么必须定期运行UPDATE STATISTICS。
应用推荐