You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

DML Operations like (Update,Delete) not working on ATPDB database table which is huge

in General Ledger & Intercompany

Summary:

DML Operations like (Update, Delete) not working on ATPDB database table which is huge.

Archive table that is present where i want to do the operation and clear data of 2024 is having 70crore records .

When I am trying to do any operation , its running for 5-6 hours , not getting completed . Then database connection getting interrupted.

I am doing simple sql queries for the operation .

Please suggest what is the way to do it .

Content (please ensure you mask any confidential information):


Version (include the version you are using, if applicable):



Code Snippet (add any code snippets that support your topic, if applicable):

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!