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。
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来摆脱一个范围型谓词，可以通过提高索引键列匹配增强性能。
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中的索引键排序(这是内存瓶颈)。
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中的索引键排序(这是内存瓶颈)。
应用推荐