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。
Step 7: Collect statistics over MQTs using runstats.
步骤7:使用runstats收集MQT上的统计信息。
Which means RUNSTATS was never executed on this table.
这意味着该表从未执行过RUNSTATS。
This article mainly USES DB2 and runstats as our example.
本文主要使用DB2和runstats作为我们的示例。
Strategies to reduce RUNSTATS impact on system performance.
减小runstats对系统性能影响的策略。
For DB2, check whether runstats has been run on the DB server.
对于DB2,检查是否在DB 服务器上已经运行了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得到单个分区的统计信息?
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值节省的空间。
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的频率。
Implement multiple concurrent RUNSTATS on different partitions for different tables.
对于不同的表,在不同的分区上实现多个并发的RUNSTATS。
You can specify the number of frequent values and quantiles on the RUNSTATS command.
只需要指定RUNSTATS命令的频率值和分位数。
Remember: Don't run the RUNSTATS utility until after you have populated the database.
记住:在填充数据库之后再运行RUNSTATS实用程序。
RUNSTATS can help you determine how performance is related to changes in your database.
RUNSTATS可以帮助您确定对数据库的更改与性能之间的关系。
Periodically run RUNSTATS when significant change to data volumes or data content occurs.
当对数据量或数据内容进行重大更改时,定期运行RUNSTATS。
It is a good idea to run a RUNSTATS-equivalent tool to gather statistics on the remote data.
运行与RUNSTATS等效的其他工具来收集关于远程数据的统计信息也是很好的做法。
Run RUNSTATS on only a few tables and indexes at a time, rotating through the set of tables.
一次仅在少数表和索引上运行RUNSTATS,在整组表中循环运行。
You ran RUNSTATS with distribution and indexes all option, allowing write access to the table.
您运行带有分布和索引所有选项的RUNSTATS,从而允许对表进行写访问。
Execute the RUNSTATS utility on a regular basis in order to obtain partition-level statistics.
按时执行RUNSTATS实用程序,以获得分区级的统计信息。
应用推荐