Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 23 Nov 2015 @ 22:26:08 GMT


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


Subj:   Re: On ANSI mode, how locks are handled when commit is not performed after update
 
From:   Frydryszak, Marek

1. condition "where a>2" enforces table read lock. Read hash lock requires something like "where a=2".

2. Even with condition a=2 it will not work, because you update primary index. New hashrow value for a:=9 will be calculated during execution of query, so your update statement locks the whole table for write.



     
  <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