Query/Script to delete an order in SAP Hybris (backend)

Question

To free-up storage in the database and increase the performance, we need to delete the previously placed orders in SAP Hybris Commerce. The orders should be deleted for a particular time frame such that only the orders older than X days should be deleted.

Can anyone help me with impex/script for deleting the previously placed orders? Impex for selecting all orders :

SELECT * from {orders}

Answer 1

These operations will create huge system load.

Hybris has own functionality for these: Data Retention Framework

You will also need to add your own select queries. You wrote that older than X days. When this X days counter start: order creation/update, delivery, return, payment, etc?