Whenever the following query runs in Data Consolidator (DC) cleanup, it takes around 70 hours to complete:
delete from DC_Account where DCAccountID in (select distinct dca.DCAccountID from (DC_Account dca left outer join Accounts a on dca.AccountID = a.account_id and dca.RoutingNumber = a.routing_num) where a.account_id is null)
Each row takes around 14 minutes to delete. DC_Account has cascade deletes to around 13 tables and delete on each row of these tables activates the triggers. Please check if the query can be optimized.
- Sybase Corporate Online Banking 8.2
- Oracle Database 11
Data Consolidator, DC, Cleanup, Oracle, long, running , KBA , FS-OLB , SAP Online Banking , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.