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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.