Enhancements for optimizing query executions

A computer system for optimizing query executions, the computer program product comprising:

• one or more computer processors, one or more computer readable storage media, and program instructions stored on the one or more computer readable storage media for execution by, at least one of the one or more processors, the program instructions comprising:
• program instructions to receive a request to transfer data from a first table to a second table;
• program instructions to detect a relationship between the first table and the second table, wherein the relationship is based on a similarity between the first table and the second table;
• program instructions to identify at least a first access path for transferring the data from the first table to the second table;
• and
• program instructions to calculate a first cost of transferring the data from the first table to the second table using the first access path based on the similarity between the first table and the second table, wherein the first cost indicates estimated processor usage to transfer the data.