Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Fragmentation and TRUNCATE vs. DROP

Fragmentation and TRUNCATE vs. DROP

From: grz02 <grz01_at_spray.se>
Date: 18 Mar 2004 03:20:49 -0800
Message-ID: <1641ee43.0403180320.6cb8185a@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US