Skip to Content
-3
Apr 29, 2020 at 05:59 AM

Delete custom table records without performance issue

126 Views

Hi,

In my custom table having more than 900 Million records.Need to delete the records without performance issue.

I have tried to read the records from based on date and time . And we have tried to delete but its going for memory dump..

DELETEFROM(tablename)WHEREzone='X'.

Could you please suggest best solution for this.