Step 7: Collect statistics over MQTs using runstats.
步骤7：使用runstats收集MQT上的统计信息。
This article mainly USES DB2 and runstats as our example.
本文主要使用DB2和runstats作为我们的示例。
For DB2, check whether runstats has been run on the DB server.
对于DB2，检查是否在DB 服务器上已经运行了runstats。
We will test PERFORMER after running runstats in a section below.
在下面的小节中，我们将在运行runstats 之后测试PERFORMER。
Ensure runstats has been done prior to the Design Advisor execution.
确保在Design Advisor执行之前运行了runstats。
Use runstats on a regular basis as part of regular database maintenance.
定期使用runstats作为常规数据库维护的一部分。
Figure 10 and Figure 11 show how runstats helped to optimize the access plan.
图10和图11显示了runstats如何帮助优化访问计划。
Otherwise, it returns the time stamp of the last time that runstats was run.
否则，它就返回最后一次运行runstats的时间戳。
You can use runstats either by using a cron job or by manually using a script.
您可以通过使用一个cron作业或手动使用一个脚本来使用runstats。
Use runstats as you normally would, or use runstats with sampling to reduce its execution time.
像通常那样使用runstats，或者利用抽样使用 runstats，以减少它的执行时间。
Whatever sampling percentage you choose, runstats allows you to sample rows (Bernoulli sampling) or pages (system sampling).
无论选择多大的抽样百分比，runstats允许对行(Bernoullisampling)或页面(system sampling)进行抽样。
RUNSTATS in partitioned databases.
分区数据库中的runstats。
RUNSTATS with a statistics profile.
包含统计信息配置文件的runstats。
RUNSTATS with column group statistics.
包含列组统计信息的runstats。
RUNSTATS authorization and user access.
包含授权和用户访问的runstats。
RUNSTATS with system page-level sampling.
带有系统页级抽样的runstats。
RUNSTATS on declared global temporary tables.
已声明的全局临时表上的runstats。
Runstats and common DB2 tuning have been done.
完成runstats和一般的DB 2优化。
RUNSTATS with frequency and quantile statistics.
包含频率和分位数统计信息的runstats。
This one command performs RUNSTATS on all tables.
这一命令对所有表执行RUNSTATS。
Avoid running RUNSTATS on tables that don't need it.
避免在不需要它的表上运行RUNSTATS。
Which means RUNSTATS was never executed on this table.
这意味着该表从未执行过RUNSTATS。
Strategies to reduce RUNSTATS impact on system performance.
减小runstats对系统性能影响的策略。
Currently, the RUNSTATS command is not supported for nicknames.
目前，RUNSTATS命令对于昵称而言还不受支持。
Thus, continue to use RUNSTATS as you would for relational data.
因此，像对待关系数据那样，继续使用RUNSTATS。
In most cases, a RUNSTATS is done after an index has been created.
大多数情况下，RUNSTATS是在创建索引之后执行的。
REORGCHK can also invoke RUNSTATS before examining the statistics.
REORGCHK还可以在检查统计信息之前调用RUNSTATS。
For small tables, issuing the RUNSTATS command would be a trivial task.
对于较小的表，发出RUNSTATS命令将是一项普通任务。
The following examples illustrate using RUNSTATS to collect statistics.
下列例子说明如何使用RUNSTATS收集统计信息？
Q: Can statistics be collected for an individual partition using RUNSTATS?
Q：能否利用RUNSTATS得到单个分区的统计信息？
应用推荐