Hartmut, > DELETE: > 1) 0.03u 0.04s 0:02.46 2.8% (already empty) > 2) 0.05u 0.06s 0:01.19 9.2% (already empty) > > TRUNCATE: > 1) 0.10u 0.06s 6:58.66 0.0% (already empty, compile runnig simult.) > 2) 0.10u 0.02s 2:51.71 0.0% (already empty)
How about some times for a full table? Incidentally, I believe that TRUNCATE has always been slightly slower than DROP TABLE. -- Josh Berkus Aglio Database Solutions San Francisco ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
