Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 03 Apr 2012 @ 10:47:56 GMT

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

Subj:   Re: Drop Table versus Delete All
From:   McCall, Glenn David

Dropping the table will require updates to the DBC tables to register that the table has gone. This will require write locks which can block other users briefly.

Delete all will simply mark the table as empty no locks on DBC tables.

  <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: 28 Jun 2020