Archives of the TeradataForum

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

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

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>>