07-30-2023, 01:49 PM
I am facing a problem with deleting all the records from a table.
I can use Truncate table. But truncate would create a snapshot of the data which would be a wastage of storage space in my scenario.
Also truncate would fail if any of the nodes are down.
So I would like to know if there is any way to delete all the records in a table without creating a snapshot that works if a node is down.
I can use Truncate table. But truncate would create a snapshot of the data which would be a wastage of storage space in my scenario.
Also truncate would fail if any of the nodes are down.
So I would like to know if there is any way to delete all the records in a table without creating a snapshot that works if a node is down.