Parallel calculation of access plans delimitation using table partitions

A system for replicating a table from a source database to a target database, the system comprising:

• a memory;
• and
• at least one processor coupled to the memory and configured to:
• determine whether the table includes a plurality of partitions, wherein the plurality of partitions comprises at least a first partition and a second partition;
• initiate a delimitation calculation of the plurality of partitions, wherein the delimitation calculation comprises a first delimitation calculation and a second delimitation calculation, wherein the delimitation calculation results in forming a first plurality of access plans in the first partition and a second plurality of access plans in the second partition, wherein the first delimitation calculation and the second delimitation calculation are initiated in parallel and wherein the first delimitation calculation comprises calculating first boundaries for the first plurality of access plans and wherein the second delimitation calculation comprises calculating second boundaries for the second plurality of access plans;
• determine completion of one of the first delimitation calculation or the second delimitation calculation;
• and
• initiate, responsive to determining the completion, an access plan calculation of the table.

A non-transitory computer-readable device having instructions stored thereon that, when executed by at least one computing device, cause the at least one computing device to perform operations comprising:

• retrieving a table to be transferred from a source database to a target database;
• determining whether the table includes a plurality of partitions, wherein the plurality of partitions comprises at least a first partition and a second partition;
• initiating a delimitation calculation of the plurality of partitions, wherein the delimitation calculation results in forming a first plurality of access plans in the first partition and a second plurality of access plans in the second partition, wherein the delimitation calculation comprises a first delimitation calculation and a second delimitation calculation, wherein the first delimitation calculation and the second delimitation calculation are initiated in parallel and wherein the first delimitation calculation comprises calculating first boundaries for the first plurality of access plans and wherein the second delimitation calculation comprises calculating second boundaries for the second plurality of access plans;
• determining completion of the first delimitation calculation or the second delimitation calculation;
• initiating, responsive to determining the completion, an access plan calculation of the table.