Archives of the TeradataForum
Message Posted: Fri, 16 Mar 2012 @ 09:36:58 GMT
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..
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|