Archives of the TeradataForum

Message Posted: Tue, 04 Jul 2006 @ 15:41:23 GMT

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

Hi,

there are good reasons for that.

1.) Many implementations have 1:1 Views with some locking modifiers to minimize unnecessary locks.

2.) A "replace view" is a transaction. You can easily modify underlying data while moving views to different versions of tables, thus delivering better data availability.

BR

Christian

makeITdone IT Services

www.makeitdone.com

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