Hi,
The following DQL lists 3.5 million Object IDs (r_object_id):
select r_object_id from ecm_inventory_mgnt where a_storage_type = 'AppONE'
I need to form a list of about 200k Object Ids at a time. Does using the date range is the only solution for my task?
Some the dates have more than 200K objects created on the same date. Then I need to specify the time also in the date clause like hh:mm:ss.
Is there any other best approach using DQL Hints like RETURN_TOP, RETURN_RANGE or any other? The DQL need not be exact. I need to prepare lists of about 200K objects in each. Using these lists I need to prepare API scripts having 'destroy,c,...' commands to destroy those objects.
Please share your knowledge and experience.
Thanks.
ta
