Archives of the TeradataForum

Message Posted: Fri, 20 Oct 2006 @ 20:17:32 GMT

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

<-- Anonymously Posted: Friday, October 20, 2006 16:05 -->

Anomy.Anom wrote:

Response:

This discussion is almost like everything else depend on the preference of individual company (very subjective indeed).

Recognize that view has some overhead (very small). Understand why one-to-one views were created. Usually to place access lock on the table so user queries does not conflict with ETL process. (Read lock blocks write lock).

It is recommended that any application view be build on top of one-to-one view in order to avoid any mistake in view creation by forgotten the access lock portion of the syntax may have impact to the ETL process and the only time one find out about those the damage had already been done. Avoid any application build on top of another application can avoid a lot of performance pitfalls.

Also, this may allow table/column name change without having to change the application view layer if done smartly.

Hope this opinion help.

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