Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Fragmentation and TRUNCATE vs. DROP
I have seen this claim in a few places that for Fragmentation reasons,
it is better to do TRUNCATE TABLE than DROP TABLE,
but I havent seen any explanation why that would be so.
Anyone knows whether this is true, and if so, what the difference would be?
Here is one such text, but I have seen it mentioned somewhere else, too:
http://www.orapub.com/cgi/genesis.cgi?p1=dwnld&bogus=zip_out&p2=na&p4=paper&p3=doc121.zip
"The dropping issue can also be reduced with the proper storage parameter management (i.e., creating fewer extents) and eliminated by simply truncating the table" Received on Thu Mar 18 2004 - 05:20:49 CST