 |
 |
Archives of the TeradataForum
Message Posted: Tue, 29 Jan 2008 @ 10:43:34 GMT
| Subj: | | Re: Locking Row for Access Stmt |
| |
| From: | | Howard Bradley |
| | if you don't require all-AMP operations against the table being locked, use the less intrusive, row hash level access lock. | |
Is there any down side to row hash locks for queries which do require all-amp operations. Our environment grew up as a typical decision support
environment and we have table locking for access as standard on all our "user access" views. As the data warehouse has matured there are now more
single amp operations performed, would converting all views to row hash locking as standard have any adverse or undesired effect on the all amp
workload ?
| |
