 |
 |
Archives of the TeradataForum
Message Posted: Mon, 02 Jul 2012 @ 12:22:28 GMT
Subj: | | Recommendation on Table Lock |
|
From: | | Anomy Anom |
<-- Anonymously Posted: Monday, July 02, 2012 04:52 -->
Hello Experts,
I wanted to apply S index on a huge table which takes long time. So, i want the other users to stay away from the same table till i finish the
task...[However, if someone will query on the same table i am working with, will be blocked by session building index]...
Can you let me know the right lock name and in case there are any pro and cons for the same ?
| |