Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 29 Jan 2008 @ 10:43:34 GMT

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

Subj:   Re: Locking Row for Access Stmt
From:   Howard Bradley

  if you don't require all-AMP operations against the table being locked, use the less intrusive, row hash level access lock.  

Is there any down side to row hash locks for queries which do require all-amp operations. Our environment grew up as a typical decision support environment and we have table locking for access as standard on all our "user access" views. As the data warehouse has matured there are now more single amp operations performed, would converting all views to row hash locking as standard have any adverse or undesired effect on the all amp workload ?

  <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