Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 23 Apr 2014 @ 21:21:32 GMT


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


Subj:   Re: Inserts Locks and Queue Tables
 
From:   Dave Wellman

Hi David,

Why is that insert an 'exclusive' lock? It should be a rowhash lock, therefor eif two txn's wrote to different PI values they will (probably) not block each other. Obviously if they wrote to the same PI value or to two PI values that generated the same rowhash then one will get blocked by the other.


Cheers,

Dave

Ward Analytics Ltd - Information in motion (www.ward-analytics.com)



     
  <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