Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 08 Mar 2002 @ 17:22:30 GMT


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


Subj:   Re: Teradata locking mechanism vs. Oracle
 
From:   Mary M. Conley

We've have used Teradata for OLTP very successfully for over 10 years. As David suggested, we utilize the dirty reads. There are 2 sets of views. The one set is for the dirty reads and the other set is used for insert, update, and delete (IUDs). So the transaction type determines which view should be used. All access is through macros.

We also wrap our IUDs with BEGIN TRANSACTION and END TRANSACTION.



     
  <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: 27 Dec 2016