Partition key adjustment based on query workload

A system configured to adjust partition keys comprising:

• a processor;
• and
• a computer-readable storage medium communicatively coupled to the processor and storing program instructions which, when executed by the processor, are configured to cause the processor to:
• identify a target table, that is a target of a query, the target table including a set of initial partitions;
• determine a set of common queries, wherein each query in the set of common queries is processed by a database, each query in the set of the common queries is configured to retrieve data from the target table, each query of the common queries includes a range for a target column the range having two endpoints, the two endpoints being a low value and a high value, and a number of times each query in the set of common queries is processed by a database exceeds a minimum threshold;
• identify a plurality of core ranges for each query in the set of common queries, wherein the core ranges are based on the low value and high value of each query;
• merge the core ranges into a new set of partitions;
• and
• set, in response to the merging, updated partition keys to mark the new set of partitions and each updated partition key is aligned with at least one endpoint of the two endpoints.

A computer program product, the computer program product comprising a computer readable storage medium having program instructions embodied therewith, the program instructions executable by a processing unit to cause the processing unit to:

• identify a target table, that is a target of a query, the target table including a set of initial partitions;
• determine a set of common queries, wherein each query in the set of common queries is processed by a database, each query in the set of the common queries is configured to retrieve data from the target table, each query of the common queries includes a range for a target column the range having two endpoints, the two endpoints being a low value and a high value, and a number of times each query in the set of common queries is processed by a database exceeds a minimum threshold;
• identify a plurality of core ranges for each query in the set of common queries, wherein the core ranges are based on the low value and high value of each query;
• merge the core ranges into a new set of partitions;
• and
• set, in response to the merging, updated partition keys to mark the new set of partitions and each updated partition key is aligned with at least one endpoint of the two endpoints.