Therefore, some partitions that do not contribute any rows for query processing are still locked when accessed via local index.
因此,在利用本地索引进行访问时,那些行与查询处理无关的分区仍被锁定。
To see if local processing is occurring for a slow performing query, there are a couple of troubleshooting techniques.
我们可以利用两个故障修复技术来了解一个执行速度较慢的查询中是否进行了本地处理。
QF (Query Framework) - internal libraries for infrastructure and integration of metadata queries, data queries, local data processing, and result sets.
QF (Query Framework) -用于元数据查询、数据查询、本地数据处理和结果集的内部库。
应用推荐