Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 16 Sep 2002 @ 17:09:37 GMT


     
  <Prev Next>   <<First <Prev Next> Last>>  


Subj:   Re: Drop the table
 
From:   Michael Larkins

Hi:

If you are dropping a table and then creating it, is it safe to say you simply want an empty table?

If so, do not drop the table. Simply do the following:

DELETE ;


It gives you an empty table and it is the fastest thing that Teradata does!

I have seen many people who are use to another database, where dropping and creating is faster. This is not your father's database that actually writes over deleted data. In Teradata, it is much slower to drop and create than to delete. Plus, you are locking the data dictionary (DD) two different times to do this. Deleting does not lock the DD.


Hope this helps.

Mike



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023