I am using an SQL in Cobol 400 to delete around 100 million records out of 200 million records based on a date. What is the best way to delete this much data in one stretch?
The file has key as date.
My sql would look like
Delete from FileA where Date < 'some date'
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!