Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 08 Jan 2002 @ 00:42:07 GMT

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

Subj:   Re: Block everybody with ALTER TABLE
From:   Todd A. Walter

re C: One advantage of ALTER TABLE is that it does NOT write a journal record for each row. It has separate block level restart logic so it can be fast and recoverable.

re C: INSERT SELECT is also a way to perform this operation. However, it requires two perm copies of the data and one spool copy. ALTER TABLE works a chunk at a time and does not require three copies of the table, pretty important for the really big ones. INSERT SELECT does not require journalling either as long as the new target table is empty and the IS is done as a standalone transaction.

Answer to original question: The AccessRights lock is the likely culprit. The reason it is necessary is that the columns being dropped MIGHT have had column level access rights defined on them that have to be removed. Those column level rights may be anywhere in the AccR table as the PI is Looks like a more efficient implementation of that removal operation needs to be on the list...

  <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