Breaking the column distribution per fragment allows for statistics management at the fragment level.
按照片段打断列分布将允许在片段级别上实现统计管理。
The analyst works with these inferences as well as the basic frequency distribution to assess the integrity of the domain or column and report findings.
分析师使用这些推断和基本频率分布来评估域或列的完整性,并报告得到的发现。
Without correct column distribution statistics, DB2 may not have enough information to make the best choice when choosing an access path to the data-especially if data is heavily skewed.
在选择数据的访问路径时,如果没有正确的列分布统计数据,DB 2可能没有足够的信息来做出最佳的选择,尤其是如果数据出现严重误差。
When distribution statistics are generated for the column "TYPE," the optimizer knows the real frequency of each model.
而一旦生成了关于“TYPE”列的分布统计信息,优化器即可了解每种型号真正的出现频率。
On the other hand, some distribution statistics, such as column frequency, have never been collected.
另一方面,有些分布统计数据(如列频度)并未收集。
Has it changed significantly enough to affect column 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就会假设值是均匀分布的,这可能导致优化器选择非最优的访问路径。
If a primary key is specified in the CREATE TABLE statement, the first column of the primary key is used as the distribution key.
如果在CREATEtable语句中指定了一个主键,那么主键的首列会被用作分配键。
Calculate the distribution of column values.
计算列值的分布。
The distribution key must consist of relational columns, and it cannot reference an XML column.
分布键必须由关系列组成,它不能引用xml列。
If you execute RUNSTATS with the additional option with DISTRIBUTION, you also get the most frequent values for each column.
如果使用附加选项WITHDISTRIBUTION执行RUNSTATS,那么还可以获得每个列中出现最频繁的值。
Using the table from the previous chapter, you can also specify the distribution for the SIZE column.
使用前一章中的所用表,您还可以为size列指定值分布。
Example 12: Collect catalog statistics on only the table, with basic column statistics for deptno and deptname and distribution statistics on mgrno and admrdept.
示例12:只收集表上的目录统计信息,包含deptno和deptname上的基本列统计信息以及mgrno和admrdept上的分布统计信息。
Example 17: Collect catalog statistics on all indexes and on column deptname with distribution.
示例17:收集所有索引上的目录统计信息,包含列deptname 上的分布统计信息。
Distribution statistics limits are set individually for the deptname column, while deptno column USES a common default.
单独为deptname列设置分布统计信息的范围,而deptno列使用公共的默认值。
The large number of distinct values in the pdb_id column ensures a relatively even distribution of rows over the database partitions.
pdb_id列中各异的值数量很大,这就确保了跨数据库分区可以获得相对均衡的行分布。
In a past column, I discussed several procedures that could be employed to accelerate application binary distribution and deployment and, in turn, update and install applications.
在之前的一篇专栏文章中,我讨论了用于加速应用程序部署的选项的几个程序,依次更新和安装应用程序。
For each distribution channel, one column that denotes the number of entries for the customer for that particular channel.
对于每一个分销渠道来说,一个列表示适用于特别渠道的客户条目的数量。
My recommendation for a Network Deployment session distribution mechanism remains the same as stated in an earlier column, which is to employ database persistence.
我对NetworkDeployment会话分发机制的建议与在 前一个专栏中陈述的建议相同,即采用数据库持久性。
What I'm saying here is that for non-index predicates, DB2 does not consider the COLCARD or the COLUMN DISTRIBUTION statistics.
我想说的是,对于非索引谓词,DB 2不会考虑COLCARD或COLUMN DISTRIBUTION统计数据。
For solving the problem, make a study of growth law and space distribution law of karstic collapse column in North China area.
为了解决陷落柱问题,文章对华北地区陷落柱的发育规律和陷落柱的空间分布规律进行了研究。
Through the theoretical calculation, the radial and axial temperature distribution of arc column and the thermal boundary region were obtained.
通过测量和分析计算获得了弧柱和热区的径向及轴向温度分布。
In a soil column culture and a field experiment, the comparison of root distribution of spreading-leaf and upright-leaf maize cultivars in Songnen Plain was studied.
采用土柱模拟栽培法与大田试验相结合的方法,对松嫩平原不同株型玉米的根系分布特征进行了比较。
The distribution of typhoon precipitation presents the positive ad negative change as the gravity wave column wise under the influence of terrain.
台风降水受地形影响呈现出类重力波列式的正负相间的变化分布。
Gradation of sand column and sediment concentration of muddy water and water head are remarkably effective factors for the fine grain distribution in sand column.
砂柱的颗粒组成、水含沙量和入渗水头对滞留分布产生显著的影响。
Conclusion the scatter plot of row and column points indicates directly the characteristics of the distribution and the inner relationship.
结论因子负荷图直观地表述了各疾病与月份之间的内在联系与分布特征。
The distribution of components inside SMB column was simulated. The results showed that the SMB process was a dynamical equilibrium system.
分析模拟移动床色谱柱内物料浓度的分布情况,表明色谱分离是一个动态平衡的过程。
The paper makes study about magnetic -field distribution of analyzing iron spectrum by using scalar-quantity magnetic column.
利用标量磁位,对分析式铁谱仪的磁场分布进行了研究。
Experiments show that microcrystal wax with a carbon distribution less than C72 can be analyzed with large diameter quartz capillary column.
实验表明,使用大口径高温毛细管柱可以分析碳数在72以下的微晶蜡。
According to the liquid flow characteristic of bubble column, we hope to decrease axial backmixing of the liquid by putting some baffles which have certain distribution rule in the bubble column.
根据鼓泡塔内液相流体的流动特点,我们希望在鼓泡塔内加入了一定数量按照一定规律排列的挡板,能够减弱鼓泡塔的液相轴向返混。
应用推荐