Listing 1. Implementation of the hash index key generator.
清单1.hash索引键生成器的实现。
We can use randomized index key columns to reduce contention, but at what cost?
我们可以使用随机化的索引键列来减少争用，但这有何代价呢？
The index key limit might be reduced when you are using VARCHAR or VARGRAPHIC data type.
当使用VARCHAR或VARGRAPHIC数据类型时，索引键限制可能减少。
Put another way, matching starts at the far left of the index key and proceeds rightward.
换句话说，匹配从索引键的最左端开始并向右匹配。
The index key size limit also applies to those constraints that are enforced through indexes.
索引键大小限制也应用于通过索引施加的那些约束。
Based on the optimizer's estimate, there are eight qualifying RIDs within the target index key range.
基于优化器的估计，在目标索引键范围内有8个合格的RID。
IDS now automatically collects index statistics on the leading index key while the index is being created.
IDS现在可以在索引创建时自动收集起始索引健上的索引统计信息。
The generated hash value is numeric, and I use this value as single index key for the string being indexed.
生成的hash值是数值型的，我使用这个值作为被索引的字符串的索引键。
It should be noted that the DB2 index key size limit is 1024 bytes, and the index key limit includes all overhead bytes.
应该注意，db2索引键的大小限制为1024字节，而且索引键限制包括占用的所有字节。
In Cheetah (IDS 11), IDS automatically collects index statistics on the leading index key while the index is being created.
在Cheetah (IDS11)中，当创建索引时，IDS自动收集起始索引键上的索引统计信息。
When you create indexes on VARCHAR or VARGRAPHIC columns in your Unicode tables, you need to pay attention of the index key limit.
在unicode表中的VARCHAR或VARGRAPHIC列上创建索引时，需要注意索引键限制。
When each functional index is created, its associated UDR is executed to pre-process the images and store the results as the index key.
在创建函数索引时，将执行与其相关的UDR来对图像进行预处理，并将结果作为索引键保存。
But be careful with this tactic; you do not want to replicate a table in an index by including all of the table's columns in the index key.
但是要小心使用这一策略；您并不想以在索引键中包含数据表所有列的方式在索引中复制一个表。
The load and create index operations always use private sorts for index key sorting, regardless of the value of the INTRA_PARALLEL parameter.
装入和创建索引的操作通常使用私有排序进行索引键的排序，无论INTRA_PARALLEL参数的值如何。
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来摆脱一个范围型谓词，可以通过提高索引键列匹配增强性能。
Moreover, the ratio between the number of records and the number of index keys indicates, on average, the number of RIDs associated with each index key.
而且，记录的数量与索引键之间的比例说明，通常，RID 的数量与每个索引键都有关联。
Also keep in mind that on AIX, there is approximately a Max of 250mb of private virtual memory for index key sorting in LOAD (this is a memory bottleneck).
还请记住，AIX上大约有最大为250MB的私有虚拟内存用于LOAD中的索引键排序(这是内存瓶颈)。
You have a join logical file, but only want the index for the key on SSD, not the secondary indexes.
您有一个连接逻辑文件，但是只希望在SSD中保存键的索引，而不是二级索引。
It queries your database, indexes each column in each row of the result, and ties each index entry to the row's primary key.
它将查询数据库，为结果的每行中的每列建立索引，并且将每个索引条目绑定到行的主键上。
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.
然而，DB 2复制要求使用一个主键或惟一索引来区分一个表中的记录。
In other words, all columns that are part of the partitioning key must be present in the primary key or unique index definition.
换句话说，作为分区键一部分的所有列都必须出现在主键或惟一索引定义中。
During the foreign key enforcement, the server USES the sequential scan, instead of foreign key index.
在外键加强过程中，服务器使用顺序扫描，而不是外键索引。
After the foreign key constraint with index disabled is dropped and recreated, the reversion completes successfully.
终止和重新创建索引禁用的外键之后，降级就成功完成了。
We keep only a compound primary key and a secondary index for each row, and answer all queries from a single index.
我们只保留了一个组合主键和一个辅助索引来完成所有的查询。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
表的主键和所有惟一索引都必须是相关分区键的超集。
An index pushdown USES the pushed-down keys to perform index lookups on a foreign key index of the fact table.
索引下推使用下推键执行事实表外键索引的查询。
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.
原因是DB2UDBSAMPLE数据库中的其他表没有主键，因此没有索引信息可以关联惟一的ECO 键。
To better illustrate the improvement in cardinality estimation, drop all the existing indexes on the EMPLOYEE table except the primary key index.
为了更好地解释说明基数估计值的提高，撤销除主键索引外的所有employee表上的现有索引。
To better illustrate the improvement in cardinality estimation, drop all the existing indexes on the EMPLOYEE table except the primary key index.
为了更好地解释说明基数估计值的提高，撤销除主键索引外的所有employee表上的现有索引。
应用推荐