输入和收集的统计信息越多,算法就越能准确地预测一系列结果。
The more inputs and statistical information collected, the better the algorithm will be at predicting a range of outcomes.
一定要与您的DBA 一起工作以确保在适当的时候积累统计信息。
Be sure to work with your DBA to ensure that statistics are accumulated at the right time.
如果所有分区都处于他们都在发送和接收数据的combo状态,那么统计信息就不能被收集。
If all partitions are in a combo state where they are both sending and receiving data, then statistics cannot be collected.
社会科学家研究从数据中得出的统计信息,而呈现这些统计数据的最佳方式通常是图表形式。
Social scientists work with statistics derived from data, and the best way to present these statistics is often in graphic form.
其他所有列不包含任何统计信息。
All other columns will not have any distribution statistics.
仅对用户表进行自动统计信息收集。
Only consider user tables for automatic statistics collection.
其他有趣的统计信息与对象分代有关。
Other interesting statistics have to do with object generations.
这些统计信息称为片段实绩。
考虑对所有表进行自动统计信息收集。
世卫组织如何收集统计信息?
JVM提供许多统计信息。
它使用来自系统编目中统计信息中的信息。
It USES the information from the statistics in the system catalog.
也可以收集HTTP连接的统计信息。
此时,计算过程中并不包含数据统计信息。
At this point, data statistics are not included in the calculations.
这个昵称在昵称创建时收集最新的统计信息。
This nickname receives the latest statistics at nickname creation time.
发布到JMS主题的信息用于收集统计信息。
Information published to the JMS topic is used for collecting statistics.
基本统计信息和分布统计信息。
表范围:确定对哪些表执行自动统计信息收集。
Table scope: Identifies which tables are considered for automatic statistics collection.
昵称可以包含列、统计信息、索引或信息约束。
Nicknames can have columns, statistics, indexes, or information constraints.
自动统计信息收集。
操作系统统计信息。
线程池统计信息。
收集包含分布统计信息的目录统计信息。
Q:能否利用RUNSTATS得到单个分区的统计信息?
Q: Can statistics be collected for an individual partition using RUNSTATS?
收集统计信息,包含10%行上的分布统计信息。
Example 29. Collect statistics, including distribution statistics on 10 percent of the rows.
收集索引上的详细抽样统计信息和表的分布统计信息。
Example 28. Collect detailed sampled statistics on indexes as well as distribution statistics for the table.
所以,应该只为那些需要分布统计信息的列生成分布统计信息。
So restrict generating distribution statistics to those columns that require distribution statistics.
自动统计信息配置则通过确定何时和如何收集统计信息更进了一步。
Automatic statistics profiling goes one step further by determining when and how to collect statistics.
可以将这些统计信息与以前版本的统计信息相比较,验证系统不存在瓶颈。
These statistics can be compared against data from a previous version and verify that there is no bottleneck on the system.
有两种不同类型的分布统计信息 ——频率统计信息和分位数统计信息。
There are different types of distribution statistics -- frequency and quantile statistics.
应用推荐