For each column in the partitioning key of the joined tables, an equijoin predicate must exist.
对于被合并的表的分区键内的每列,必须存在一个同等连接的谓语。
So a different solution was found if an identifying column like a primary key is found in the table.
所以,如果在表中找到一个标识列,例如主键,则可以找到一种不同的解决方案。
To convert an existing column into a primary key, click on the column (property in the class) in the diagram.
要转换一个已有的列成为一个主键,在图中点击这个列(类中的属性)。
The application never knows what value is put into the primary key column after running the INSERT statement.
在运行insert语句之后,应用程序将永远都不知道放入了主键列中的是什么值。
Now you can relate the extracted concepts with the key ID, because this column is also contained in the operator output.
现在您可以将提取的概念与键ID关联起来,因为该列也被包含在操作符输出中。
When you create a table, you can add an extra column to be the surrogate key.
当创建一个表时,可以添加一个额外的列作为代理键。
If one is not supplied, one is created by default from the first column of the primary key.
如果没有提供分区键,则默认地从主键的第一个列创建分区键。
It can be used to generate unique values for the surrogate key column.
我们可以使用该函数为代理键列生成惟一值。
Also in the query rewrite vein, modifying a SELECT to get rid of a range-type predicate can increase performance by improving index key column matching.
另外,在查询重写状态下,修改SELECT来摆脱一个范围型谓词,可以通过提高索引键列匹配增强性能。
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.
分区键是用于确定特定一行数据存储在哪个分区的一个列(或一组列)。
Note, however, that we cannot update the primary key columns or any other key columns that you declare; in this case, EMP_ID is a primary key column.
但是请注意,我们不能修改您声明的主键列或任何其他的键列;在本例中,EMP _ ID是主键列。
In Listing 5, you have a standard primary key column called PO_ID (that is, purchase order ID).
在清单5中,您有一个称为PO_ID的标准主键列(即订单id)。
Now you are able to relate the extracted concepts with the COUNTRY key, because this column is also contained in the operator output.
现在,可以把提取的概念与COUNTRY键关联起来,因为操作器输出中也包含这个列。
If using the above CSV file to retrieve a state name based on a state abbreviation, you can set up the lookup to use column 1 as the key column and column 0 as the value column.
如果使用以上CSV文件根据国家缩写检索一个国家名,您可以设置查找来使用列1作为键列,并将列0作为值列。
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语句中指定了一个主键,那么主键的首列会被用作分配键。
When doing a lookup in a CSV file, the properties allow you to specify which column is used as the key column, and which is used as the value column.
当在CSV文件中执行一个查找时,属性允许您指定将哪个列用作键列,以及将哪个列用作值列。
Whether a column should be used as table partitioning key for TP is not affected by whether that column is also used an MDC dimension and vice versa.
一个列是否被用作MD c维对于是否应该将它作为表分区键没有影响,反之亦然。
If there is no primary key, the first column that is not a long field is used.
如果没有主键,就会使用非长型字段的首列。
An arbitrary key is one column and is almost always smaller than an operationally derived key.
任意键是一列,通常比操作派生的键要小。
Figure 24 defines the column to be used as the key to check the duplicate records.
图24定义了列,用作检查重复记录的键。
In this sample, it is assumed that every contact record has a unique E-mail address that is used as the "Key" column.
在这个示例中,假设每个联系方式记录都有一个惟一的e - mail地址,作为“Key”列。
In this form, we can tell Domino which field is the key field and how this field maps to the DB2 key column.
在该表单中,我们可以告诉Domino哪个字段是关键字段,以及如何将该字段映射到DB 2键列。
Rails USES the primary key column id for various recordkeeping and referencing tasks.
Rails使用主键列id来完成各种记录保持和引用任务。
The XML Input stage uses a Key column to identify the repetition element, which determines how the XML data is generated.
XMLInput阶段使用Key列标识重复元素,这决定如何生成 XML数据。
If the join key is a composite key, each key column must be prefixed with the PRIOR operator.
如果联接键是一个复合键,那么必须使用PRIOR运算符为每个键所在的列加上前缀。
Listing 6 defines the relation between a column and a primary key, also represented by Figure 5 following. The relation ensures that.
列表6定义了一个列与一个主键之间的关联,后面的图5也表示了这点。
If informational check constraints exist on the primary key column, you should explicitly specify informational check constraints on their corresponding foreign key columns. For example.
如果在主键列上存在信息检查约束,那么应该在它们相应的外键列上指定信息检查约束。
DurationLabel: Identifies the duration that is associated with the Constant value specified if the partitioning key column has been assigned a date, time, or time stamp data type.
DurationLabel:如果分区键列的数据类型是日期、时间或时间戳,这个参数指定与Constan t值相关的时间单位。
In the Box 1 (of Figure 21), you will need to select the key field in Company.nsf application and map it to the key column in DB2.
在(图21的)Box1中,您需要选择Company .nsf应用程序中的关键字段,并将之映射到DB 2中的键列。
An inner join is essentially the intersection of two tables, where the tables are matched by comparing the values of a key column, such as itemNumber.
内连接实际上是两个表的交集,它通过比较关键列(比如itemnumber)的值来匹配表。
应用推荐