IS-IH Migration script runs for long and does not complete
Interaction Services (IS)-Interaction History (IH) Migration script is running for a long time.
The below query runs for more than two hours without completion. The script is run to migrate 5 million records.
UPDATE IS_FACT_RESPONSE_ROOT SET IS_FACT_RESPONSE_ROOT.ROOT_ID = (
SELECT CASE WHEN PARENT_ID IS NULL THEN FACT_RESPONSE_ID ELSE PARENT_ID END
The requirement is to remove the upgrade query from the script.
Steps to Reproduce
Run the query.
The update query is in place to migrate the interactions set for Bundles and Multilevel decisions. If all IH entries have an empty parent_id field, it is safe to drop the update.