Archives of the TeradataForum
Message Posted: Mon, 23 Nov 2015 @ 22:26:08 GMT
| Subj: || || Re: On ANSI mode, how locks are handled when commit is not performed after update |
| From: || || Frydryszak, Marek |
1. condition "where a>2" enforces table read lock. Read hash lock requires something like "where a=2".
2. Even with condition a=2 it will not work, because you update primary index. New hashrow value for a:=9 will be calculated during execution
of query, so your update statement locks the whole table for write.