Archives of the TeradataForum

Message Posted: Fri, 16 Mar 2012 @ 09:36:58 GMT

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

By mentioning an explicit 'Access lock', you allow 'Write' operations to happen on the table being read. The result from this statement, however, will be inconsistent across multiple selects due to updates happening simultaneously. If you do not want a higher priority insert statement to wait while issue a read command, you can use access locks during the read operation.

During a read operation (select) on a table, by default Teradata applies a 'Read' lock on the table which prevents any 'Write' lock (for Insert or Update or Delete) and Exclusive lock (for DDL commands).

Your second question is not very clear to discuss about..

Regards,

Sowmya

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