E G Nidheep
E G Nidheep

Reputation: 11

Delete Rows, Just before Drop table

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

Answers (1)

E G Nidheep
E G Nidheep

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

Related Questions