Automatically Optimizing Resource Usage on a Target Database Management System to Increase Workload Performance

Loading a set of data into a target database management system (DBMS) from a source DBMS to increase workload performance and decrease resource usage is provided. Using a size and a change rate of tables eligible to be offloaded to the target DBMS, a total central processor unit (CPU) cost corresponding to loading the set of data into to the target DBMS and workload cost savings corresponding to executing one or more workloads on the target DBMS is determined based on a set of one or more load strategies. The total CPU cost is compared with the workload cost savings of each load strategy. An optimal load strategy is selected based on comparing the total CPU cost with the workload cost savings of each load strategy. The set of data is automatically loaded into to the target DBMS from the source DBMS in accordance with the selected optimal load strategy.