Again, you can see the distribution of values in each segment.
同样,您在每一个细分上都可以看到值的分布。
In this case, the optimizer assumes an even distribution of all values in COLUMN_Y, which means it assumes that all values have the same frequency.
在这种情况下,优化器认为所有值在COLUMN_Y中是平均分布的,这意味着它认为所有的值都有相同的出现频率。
The script checks the distribution statistics to find the system default as one of the most frequent values.
该脚本检查分布统计信息,以发现作为出现最频繁的值之一的系统默认值。
Predicates with concrete values are important for the optimizer to be able to use available distribution statistics.
为使优化器能够使用可用的分布统计信息,带有具体值的谓词极为重要。
The frequency distribution is stored in the metadata repository as a distinct set of values with their associated count of occurrence.
频率分布存储在元数据储存库中,其形式为一组不同的值和与之相关的出现次数计数。
In other words, if you have 90% of your values between a certain range, the frequency distribution would tell you what the outlying values are and may indicate a quality issues in those outliers.
换句话说,如果有90%的值落在某个范围内,那么频率分布将告诉您有什么生僻的值,并且可能表明那些生僻的值存在质量问题。
The screen shot in Figure 5 below shows the graphical representation of a frequency distribution and shows a highly skewed set dominated by a pair of values.
图5中的屏幕截图显示了频率分布的图形化表示,并显示了由一个值对支配的高度倾斜的集合。
This article discusses how to make up a test data set so that it is large enough to be useful for testing and has the expected distribution of values and correlation between columns.
本文讨论了如何构建一个测试数据集,以使该数据集达到用于测试的规模,并且具有期望的值分布和列间相关性。
Results are readily displayed and allow the user to quickly understand duplicated values or drill back into the full frequency distribution for single or multiple columns as Figure 11 shows.
评价结果立即显示出来,使用户可以快速理解重复的值,或者回过头查看单个或多个列的全部频率分布,如图11所示。
Although the access plan is better than the access plan with concrete values without distribution statistics, it is worse than the access plan with concrete values with distribution statistics.
虽然这个访问计划比使用具体值但没有分布统计信息情况下的访问计划好,但不如既使用具体值又有分布统计信息时的访问计划。
Bad distribution of hash values.
糟糕的散列值分配。
A nice little histogram showing me the values I get, and we will come back to this later and talk about why this is called a normal distribution.
这是一个很好的柱形图,它能告诉我我获得的值是多少,我们下一次还会讲到这个柱形图,并且会讲到为什么它被称作,正态分布。
Without column data-value distribution information in the catalog, DB2 will assume an even distribution of values, which may lead the optimizer to a sub-optimal access path.
如果编目中没有列数据值分布信息,DB 2就会假设值是均匀分布的,这可能导致优化器选择非最优的访问路径。
The table has exactly the required distribution of values.
该表刚好具有所需的值分布。
The spread of the distribution, called its variability, indicates the degree to which observed values will vary from the mean.
这些值的分布状态的扩展称作可变性,表示观测值偏离中间值的程度。
While the most extreme cases involve smaller, less developed countries, the same distribution also applies to more developed ones-and with much larger absolute values for GDP loss.
虽然最极端的案例包括了较小的、发达程度不足的国家,同样的分布情况也适用于更为发达的国家—其GDP损失绝对值要大得多。
As the optimizer is not aware of the uneven distribution of the STATE values, it decides to use the index I_TYPE.
由于优化器不知道state值不是均匀分布的,因此它决定使用索引i _ TYPE。
Where the frequency distribution shows data values decreasing in occurrence from some common condition to a rare condition, a skew exists.
如果频率分布显示数据值从经常出现变为很少出现,则存在倾斜。
Calculate the distribution of column values.
计算列值的分布。
The hash code should provide a uniform distribution of values over the key space so that the partitions are evenly balanced.
散列码应该在键空间上提供均匀的值分布,以便分区负载平衡。
The attribute that has the widest distribution of values is considered the best candidate to be the first question asked in the next cycle.
其值分布最广的属性最适合在下次循环中作为第一个问题提出。
Instead of this single value, a random variable has a function that describes the likelihood of values for the estimate and is called the variable's probability distribution.
取代单个值,随机变量拥有描述估计值可能性的函数,该函数称为变量的概率分布。
If you execute RUNSTATS with the additional option with DISTRIBUTION, you also get the most frequent values for each column.
如果使用附加选项WITHDISTRIBUTION执行RUNSTATS,那么还可以获得每个列中出现最频繁的值。
Generate data with given distribution of values for several columns.
为几个列生成具有给定值分布的数据。
The low mode populates only the scalar statistical values (that is, no distribution information) of a table.
low模式只填充表的标量统计值(也就是说,没有分布信息)。
The number of distinct values must be great enough to ensure an even distribution of rows across all database partitions in the database partition group.
distinct值的数量必须多到足以确保数据行均匀地分布在数据库分区组中的所有数据库分区上。
The Heat Map displays values on either a clustered, linear or logarithmic scale, to help spot uneven distribution of data across threads.
“HeatMap”中能够以集群(clustered)、线性(linear)或者对数(logarithmic)的方式显示值,以帮助我们跨线程识别出对数据的不平均分布。
The large number of distinct values in the pdb_id column ensures a relatively even distribution of rows over the database partitions.
pdb_id列中各异的值数量很大,这就确保了跨数据库分区可以获得相对均衡的行分布。
This is why the shape of the Chi Square sampling distribution changes for different df values.
这就是为什么X平方分布的抽样分布的形状随着df值的不同而变化的原因。
This parameter allows you to specify the number of "most frequent values" that will be collected when the WITH DISTRIBUTION option is specified on the RUNSTATS command.
该参数允许您指定“高频值(mostfrequent values)”的数目,当在RUNSTATS命令上指定WITHDISTRIBUTION选项时,将收集该值。
应用推荐