这两组列都可以编制索引,但是使用不同的索引。
Both sets of columns may be indexed, but by different indexes.
可以为单个列或一组列修改频率和分位数统计信息的精确度。
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.
当您想要在滚动或查看其他列数据时冻结一个或一组列时将会很有用。
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.
列组(ColumnGroup)统计信息将获得一组列的不同值组合的数目。
Column group Statistics obtains the number of distinct combinations of values for a group of columns.
可在整个列上计算聚合,或者由作为函数的第二个参数所给出的分组列指定的子组上计算聚合。
You can compute aggregations on the whole column, or on subgroups that are specified by the grouping column given as the second parameter of the function.
分区键需要位于高度惟一的一列或一组列上,从而确保数据均匀分布在该表所定义的所有分区上。
The partitioning key needs to be on a column or set of columns that are highly unique thus ensuring that the data will be evenly distributed across all the partitions that the table is defined on.
分区键(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.
该部分创建了一个名称为“CATEGORIZED”的虚拟表,表中带有inner查询提供的一组列。
This creates a virtual table by the name "CATEGORIZED" with a set of columns supplied from inner queries.
对于单一分组集或多个分组集,分组列的次序是无所谓的;但是对于ROLLUP,列的次序不能随意安排。
While the ordering of the grouping columns does not matter for a single grouping set or multiple grouping sets, the order of the columns does matter for ROLLUP.
如果基于查询工作负载选择一个分区键,那么此分区键通常应该包含一个合并列或常被用于很多查询的一组列。
If you choose a partitioning key based on your query workload, the partitioning key should typically consist of either a joined column or a set of columns that is frequently used in many queries.
有时候,列组或类似的统计选项会很有用。
Sometimes, column group, or like statistics options can be useful.
包含列组统计信息的runstats。
复制模板包含数据库的架构信息、一组表、列属性、标识行的主键。
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.
第一列是组的名字。
列组的使用将给多个谓词的联合选择提供更准确的估计。
The use of column groups provides more accurate estimates of the joint selectivity of multiple predicates.
示例19:收集捕获了列组的目录统计信息。
Example 19: Collect catalog statistics that capture column groups.
两个或多个子项内引用的不同列组
Different sets of columns referenced in two or more subterms
第三列是组的一个数字索引。
本例中,总共有两个列组:(deptno,deptname)和(admrdept,location)。
In this case, there are two column groups: (deptno, deptname) and (admrdept, location).
收集单个列的统计数据还不足以提供所需信息,因此您需要收集列组统计数据。
Collecting statistics of individual columns may not be enough to provide the information required, so you need to collect column group statistics.
这个例子解释说明了列组统计信息对一个合格的OR谓词的影响。
This example illustrates the effect of column group statistics on a qualifying OR predicate. Consider the following query on the EMPLOYEE table.
记录或行包含一组包含了数据的字段或列。
A record or row contains a set of fields or columns containing data.
表的一个通用模式是每一列包含一组重复的单元格。
The generalized pattern across the table is that each column contains a repeating group of cells.
在TDT面板的右侧,你将看到两列的TestData组:"In"和 "Expected"。
On the right side of the TDT pane you'll see a Test Data group with two columns: "In" and "Expected."
BREAK命令可用于基于特定列值将报表分成一组记录。
The break command can be used to break the report into a set of records based on a particular column value.
第四列是关联到这个文件的组,mygroup。
The fourth column contains the group associated with the file, mygroup.
在图5中,RegexGroups函数定义与RegexMatches函数定义一样,除了它还返回匹配项中包含组名称的其他数据列。
In Figure 5, the RegexGroups function is defined like the RegexMatches function except that it returns an additional column of data containing the name of the group within the match.
使用jiffies作为时间粒度,定义了几个组,它们表示将来的过期时段(其中每个组通过一列计时器表示)。
Using jiffies as the granularity of time, a number of groups is defined that represents future periods of expiration (where each group is represented by a list of timers).
应用推荐