Truncate table Vs Drop table?
626474Jun 26 2008 — edited Jun 27 2008Hi all,
As I know the Truncate table command is not going to reduce tablespace size unless use "Drop table" command, is that right?
For example: there is a table named as "A" and I always upload around 30,000 records into this table, everytime I will truncate the table and insert the new records. There is a unqiue index created for the table "A", the size of the index is going very fast, if I going to use "Truncate table" commnad is not going to help fragmentation for the index....am i right?
Best Regards,
Fan