|
|
|
An enhancement improves the performance of range retrieval with equality search on a full unique key. When a range search is performed on a unique index and the range criteria specify an equality match on all segments of the key, we can call EQLKEY() instead of GTEKEY(). For a partitioned file global-unique index that does not cover the partition key, this greatly improves performance when many active partitions exist. This is because EQLKEY() can use the global unique partition host index to find the partition that contains the key value.
Prior to this modification, the range search function called GTEKEY(), which required calling GTEKEY() on each partition and returning the minimum key value found.
