此外,在DB 2中创建复制之前,您会希望保证每一个数据库表都具有一个主键或惟一索引。
Also, before setting up replication in DB2, you will want to ensure that every database table has a primary key or unique index.
然而,DB 2复制要求使用一个主键或惟一索引来区分一个表中的记录。
However, DB2 replication requires a key or index to uniquely identify rows in a table.
表的主键和所有惟一索引都必须是相关分区键的超集。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
首先在逻辑上将表与其自身连接,然后将更具有选择性的非起始索引键作为索引绑定过滤器,应用于起始键值的每个惟一的组合。
The table is logically joined to itself, and the more selective non-leading index keys are applied as index bound filters to each unique combination of the leading key values.
原因是DB2UDBSAMPLE数据库中的其他表没有主键,因此没有索引信息可以关联惟一的ECO 键。
The reason for this is that the other tables in the DB2 UDB SAMPLE database have no primary key, and hence no index information to associate a unique ECO key with.
正如在关系数据库中那样,BigTable中的数据可以组成具有行和列的表,且每一行都有一个惟一的索引id。
As in a relational database, data in BigTable can be organized into tables with rows and columns, and each row has a unique indexed ID.
ccd表中必须有惟一性约束——可以通过主键或者源表或ccd表上的惟一索引实现。
Uniqueness in the CCD table must be enforced — either by a primary key or unique index on the source table or CCD table.
ccd表中必须有惟一性约束——可以通过主键或者源表或ccd表上的惟一索引实现。
Uniqueness in the CCD table must be enforced — either by a primary key or unique index on the source table or CCD table.
应用推荐