Select the three actions on this page in order.
This step will compare the performance differences between TRUNCATE and DELETE.
Run TRUNCATE time test
Truncate rows in the 1k, 5k, 10k, 50k and 100k tables and record the time required to perform each operation.
Graph TRUNCATE times
Plot the TRUNCATE performance data on the graph.
Compare DELETE vs. TRUNCATE times
Adds performance data from previous DELETE operations to the graph for comparison.
After running the three actions you should see a graph in the lower right panel comparing the performance differences between the two commands. Note that TRUNCATE performs consistently even with larger data sets.