Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 16 Mar 2012 @ 09:36:58 GMT


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


Subj:   Re: Locking within views
 
From:   Sowmyalakshmi.Thirumoorthy

By mentioning an explicit 'Access lock', you allow 'Write' operations to happen on the table being read. The result from this statement, however, will be inconsistent across multiple selects due to updates happening simultaneously. If you do not want a higher priority insert statement to wait while issue a read command, you can use access locks during the read operation.

During a read operation (select) on a table, by default Teradata applies a 'Read' lock on the table which prevents any 'Write' lock (for Insert or Update or Delete) and Exclusive lock (for DDL commands).

Your second question is not very clear to discuss about..


Regards,

Sowmya



     
  <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: 23 Jun 2019