Archives of the TeradataForum
Message Posted: Fri, 08 Mar 2002 @ 17:22:30 GMT
| 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.