title: Fastest way to delete all the data in a large table
body: <p>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:</p>
  
  <p>delete from client_log</p>
  
  <p>which took a very long time.</p>