How to perform a cleanup table to improve the DB performance?

[SAPSupport]

Can you please delete data to improve the DB performance?

Also please advice for any jobs we can run to delete the same periodically.

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

Hello Vishnu,

I'm Sabrina from SAP Commerce Cloud Team and I was just assigned to your case now.
To delete the records from your database in HAC we recommend to perform it from your side.
For that, you can read the SAP community blog How to Reduce Database Storage on SAP Commerce Cloud.
Where in this link you can also check how to perform a regular clean up.

I believe that I could answer your question.
Please note your feedback is very important for us therefore kindly familiarize yourself with KBA 1239839 and fill in the SAP Support Interaction Survey about the ticket you are closing.
We will be looking forward for your answers and comments.

Kind Regards,
Sabrina
Support Engineer, Commerce Cloud