|
|
|
When a key search occurs on partitioned indexes that are not ordered as the partition key, all the partition members must be opened, which can take a significant amount of time if the number of partitions is large. One operation where unnecessary time was spent was resizing (allocate new + copy + free old) a user’s file control block. Previously, this grew in increments of 32 (MAXMEMB + 1) files.
With partitioned files accessed via SQL, thousands of files may be opened by a single query. This change increases the rate at which this array grows by doubling in size up to 2,000 files and reduces the total query time by 4% in a case with 1,000 files.
