注意如果扩展分区其中包含的任何一个分区(包括交换空间)正在使用,那么它是以这种方式锁定的。
Note that the extended partition is locked in this way if any of its contained logical partitions are in use, including swap space.
然而,对于本地索引扫描,需要锁定的分区首先要做索引搜索并发现匹配。
However, with local index scans, a partition needs to be locked first to do the index look-up and find a match.
只有发现了引用,分区才锁定。
因此,在利用本地索引进行访问时,那些行与查询处理无关的分区仍被锁定。
Therefore, some partitions that do not contribute any rows for query processing are still locked when accessed via local index.
发生这一问题的原因在于数据库内的索引锁定或锁存(例如事务处理日志周围的索引锁定或锁存),直到该应用程序使用分区数据库为止。
This happens because the index locks or latches within the database (such as those surrounding the transaction log) until the application is using a partitioned database.
发生这一问题的原因在于数据库内的索引锁定或锁存(例如事务处理日志周围的索引锁定或锁存),直到该应用程序使用分区数据库为止。
This happens because the index locks or latches within the database (such as those surrounding the transaction log) until the application is using a partitioned database.
应用推荐