I have a purging process that runs to delete old data from table to avoid table growth.
My delete statement would be a simple delete based on join something like below
Delete FROM TABLE_A A JOIN TABLE_B B ON A.Key = B.Key WHERE SOME CONDITION
The statement is NOT in a transaction, so when the statement timesout, there should not be any rollback. But for me the transaction is getting rollbacked. I dont understand how this is happpening. I dont want any delete that happened to rollback on purging process. Can someone please explain me why rollback occurs?