两个或多个子项内引用的不同列组
Different sets of columns referenced in two or more subterms
包含列组统计信息的runstats。
有时候,列组或类似的统计选项会很有用。
Sometimes, column group, or like statistics options can be useful.
示例19:收集捕获了列组的目录统计信息。
Example 19: Collect catalog statistics that capture column groups.
列组的使用将给多个谓词的联合选择提供更准确的估计。
The use of column groups provides more accurate estimates of the joint selectivity of multiple predicates.
这个例子解释说明了列组统计信息对一个合格的OR谓词的影响。
This example illustrates the effect of column group statistics on a qualifying OR predicate. Consider the following query on the EMPLOYEE table.
收集单个列的统计数据还不足以提供所需信息,因此您需要收集列组统计数据。
Collecting statistics of individual columns may not be enough to provide the information required, so you need to collect column group statistics.
下列例子说明了如何使用RUNSTATS收集捕获了列组信息的目录统计信息
The following example illustrates using RUNSTATS to collect catalog statistics that capture column group information
列组(ColumnGroup)统计信息将获得一组列的不同值组合的数目。
Column group Statistics obtains the number of distinct combinations of values for a group of columns.
本例中,总共有两个列组:(deptno,deptname)和(admrdept,location)。
In this case, there are two column groups: (deptno, deptname) and (admrdept, location).
在没有列组统计信息的情况下再次收集统计信息的话,优化器会选择一个类似如下所示的查询访问计划,它的基数估计值为2。
A query access plan similar to the following is chosen by the optimizer, with a cardinality estimate of 2.
在没有列组统计信息的情况下再次收集统计信息的话,优化器会选择一个类似如下所示的查询访问计划,它的基数估计值小于2。
A query access plan similar to the following is chosen by the optimizer, with a cardinality estimate under 2.
而所用密码算法在设计上要使从两组不同数据得到同一个散列值——即“碰撞”——的概率极其小。
The algorithms are designed so that the probability of two different sets of data computing the same hash value — a collision — is extremely small.
第一列是组的名字。
第三列是组的一个数字索引。
可以为单个列或一组列修改频率和分位数统计信息的精确度。
The precision for the frequency and quantile statistics can be modified for an individual column or a group of columns.
分区键是用于确定特定一行数据存储在哪个分区的一个列(或一组列)。
A partitioning key is a column (or group of columns) that is used to determine the partition in which a particular row of data is stored.
第1列包含AIX组名,第2列包含成员总数。
Column one contains the actual AIX group names and column two contains the total members.
第一列是要设置的新gid,第二列是组名称。
The first column has the new GID that you want set, and the second column has the group name.
这两组列都可以编制索引,但是使用不同的索引。
Both sets of columns may be indexed, but by different indexes.
分区键(partitioned key)是指一列或一组列,用于确定特定行数据所存储的分区。
A partitioned key is a column, or group of columns, used to determine the partition in which the particular row of data is stored.
当您想要在滚动或查看其他列数据时冻结一个或一组列时将会很有用。
Column locking is useful for when you want to freeze a column or collection of columns while scrolling and reviewing data in the other columns.
由背部一组两列竖排表面穿环组成。
They are a series of surface piercings arranged up the back in two vertical columns.
模板使用关于数据库的模式信息、一组表、列和主键定义一组主副本和一个副本集。
A template USES schema information about a database, a group of tables, columns, and primary keys to define a group of master replicates and a replicate set.
它应该返回两个列,第一列中包含用户名,而第二列中包含组名。
It should return two columns, the first holding a username and the second holding a group name.
这五列的重复组(我称之为列的period,因为没有更好的术语)的大小为4、8、16、32和 64。
The sizes of the repeating groups (which I'll call the period of the column, for lack of a better term) are 4, 8, 16, 32, and 64 for the five columns.
表的一个通用模式是每一列包含一组重复的单元格。
The generalized pattern across the table is that each column contains a repeating group of cells.
将组MYDBCard从输入卡拖放到输出卡组规则列。
Drag and drop the group MYDBCard from the input card to the output card group rule column.
复制模板包含数据库的架构信息、一组表、列属性、标识行的主键。
Replication templates contain schema information about a database, a group of tables, column attributes, and the primary keys that identify rows.
模板由关于数据库的模式信息、一组表、列属性和标识行的主键构成。
A template consists of schema information about a database, a group of tables, column attributes, and the primary keys that identify rows.
应用推荐