Sql-server – Fastest way to delete all the data in a large table


I had to delete all the rows from a log table that contained about 5 million rows. My initial try was to issue the following command in query analyzer:

delete from client_log

which took a very long time.

Best Solution

Check out truncate table which is a lot faster.