@SumitM_X agreed as most of the databases uses btrees as underlying data structure and every hard delete trigger tree rebalancing which adds extra overhead after each delete transaction. so soft deleteand hard deleting all the flagged rows during off peak hours is better design choice