1. 8
  1. 4

    There are days when I just want to ON TRUNCATE CASCADE and watch the world burn.

    1. 2


      Are you Little Bobby Tables? https://xkcd.com/327/

    2. 1

      I had to put this to the test recently, and found that there some nuances to truncate. When removing millions of records, truncate is the way go. With delete, I was waiting for hours (slow due to table scan), with truncate, seconds. However, one thing that the article glosses over is the impact of foreign key indexes on truncate. Some planning is needed in the table design if you want to use truncate.