Archives of the TeradataForum

Message Posted: Thu, 05 Mar 2009 @ 22:34:56 GMT

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

Hi,

You definitely have the advantage of using the views with access lock instead of base tables directly.

The access lock avoid potential read locks and also you can access the tables that have write locks on them. Please be aware that there could be some dirty reads with access locks.

Go through the documentation on variety of locking mechanisms in teradata and you will be able to take the advantage of access locks.

I'm surprised to know that all your operations are directly against the base table and you are not facing any locking issues. May be you are specifying the access lock specifier in your code that access the base tables, please verify.

I've not heard of any other advantage in terms of performance in using views instead of base tables.

Thanks,

Sudheer.

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