This means that an exclusive lock is always placed on the indexed table while a functional index is being created or dropped.
这说明,在创建或删除函数索引时,执行索引的表中始终持有一个排他锁。
The load utility accomplishes this by requesting a super exclusive (Z) lock on the table and retaining this lock for the duration of the load operation (see Listing 4).
load工具实现这一点的方法是,请求目标表上的一个超级排他(Z)锁,并在加载操作期间一直持有这个锁(参阅清单4)。
The import utility accomplishes this by requesting an exclusive (X) lock on the table at the beginning of an ALLOW NO ACCESS import operation.
import工具实现这一点的方法是在ALLOWNOACCESS导入操作的开始请求目标表上的一个排他(X)锁。
When you use the ONLINE keyword, DDL operations execute without applying an exclusive lock to the table on which the specified index is defined.
在使用ONLINE关键字时,DDL操作是在没有将排它锁应用于定义特定索引表的情况下执行的。
So we can see 3 active locks: exclusive lock on key (row) level and 2 intent-exclusive locks on the page and table levels.
我们看到了3个锁信息,一个排它锁在行记录上,两个意向排它锁在页级以及数据表对象上。
So we can see 3 active locks: exclusive lock on key (row) level and 2 intent-exclusive locks on the page and table levels.
我们看到了3个锁信息,一个排它锁在行记录上,两个意向排它锁在页级以及数据表对象上。
应用推荐