Reputation: 11
I heard like deleting all rows before dropping table will improve performance. I looked into Web, but couldn't find any reliable answers. Please share whether this is true and the reason behind. Also is the overall performance i.e, ( delete all rows + drop empty table ) is better than dropping table with all rows ?
Upvotes: 0
Views: 453
Reputation: 11
Deleting all rows before Drop is additional expense. Dropping with and without rows doesn't have much difference. ( tried with 1M rows )
Upvotes: 1