What is fastest way to insert millions rows of data to another table
Hi,
We have weekly a maintenance job to refresh all the data. One of the process to load data from a staging table to the target table as simple as
INSERT /*+ append */ INTO my_table
SELECT /*+ parallel(mst, default) */ FROM my_staging_table mst
WHERE id = :id
id is indexed, and my_staging_table contains 55 millions rows. Once the processing is loading 35 millions rows, it takes more than 7 hours.
Does anyone have any recommendation how to speed up the processing?
Thanks