Change the WHERE in the update query to use the source table columns.
Commit to the database after each chunk, not after each table.
Context for reviewers
Observing the queries on the PostgreSQL RDS and Oracle sides, we saw that the WHERE ... IN (...) was not being pushed down to Oracle. This is an attempt to fix that.
Summary
Fixes #1998
Time to review: 5 mins
Changes proposed
WHERE
in the update query to use the source table columns.Context for reviewers
Observing the queries on the PostgreSQL RDS and Oracle sides, we saw that the
WHERE ... IN (...)
was not being pushed down to Oracle. This is an attempt to fix that.Additional information
N/A