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。
Ensure runstats has been done prior to the Design Advisor execution.
确保在Design Advisor执行之前运行了runstats。
Figure 10 and Figure 11 show how runstats helped to optimize the access plan.
图10和图11显示了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，以减少它的执行时间。
Each of these operations: redistribute, table reorg, index create, and runstats require scanning the table data once.
这些操作中：redistribute、table reorg、indexcreate和runstats，每个操作都需要扫描一次表数据。
Whatever sampling percentage you choose, runstats allows you to sample rows (Bernoulli sampling) or pages (system sampling).
无论选择多大的抽样百分比，runstats允许对行(Bernoullisampling)或页面(system sampling)进行抽样。
The runstats utility can be used to update statistics in system catalog tables to facilitate the query optimization process.
可以使用runstats实用程序来更新系统编目表中的统计信息，使查询优化过程更容易一些。
RUNSTATS in partitioned databases.
分区数据库中的runstats。
RUNSTATS with a statistics profile.
包含统计信息配置文件的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。
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命令对于昵称而言还不受支持。
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得到单个分区的统计信息？
Run RUNSTATS on the following three tables from a command line, as follows
在命令行中对下列三个表运行RUNSTATS，如下所示
If the catalog statistics are inaccurate, get them up to date with RUNSTATS.
如果编目统计数据不准确，应该使用RUNSTATS更新它们。
RUNSTATS collects the necessary data to calculate the savings through NULL values.
RUNSTATS收集必要的数据，以计算通过null值节省的空间。
Both the RUNSTATS and REORG utilities use log files when moving table data around.
当到处移动表数据时，RUNSTATS和REORG实用程序都使用日志文件。
It is allocated when the RUNSTATS utility is started, then freed when it completes.
它是在启动RUNSTATS实用程序时分配的，然后当它完成时释放。
Adjust the frequency of RUNSTATS depending on how fast data is changing in a table.
根据表中数据发生改变的速度，调整RUNSTATS的频率。
应用推荐