因此，在利用本地索引进行访问时，那些行与查询处理无关的分区仍被锁定。
Therefore, some partitions that do not contribute any rows for query processing are still locked when accessed via local index.
因为只在新附加分区上构建这一本地索引，并需要非常有限的日志，所以与全局索引相比，SETINTEGRITY甚至明显变快了。
Since this local index build happens only on the newly attached partition and requires very limited logging, SET INTEGRITY is still significantly faster compared to global indexes.
Q：每个分区的本地索引分区和数据分区能否处于同一表空间中？
Q: Can the local index partition and data partition be in the same table space for each partition?
如同其所基于的表一样，本地索引也进行了分区。
Local indexes are partitioned in the same way as the table they are based on.
默认情况下，大部分用户所创建或者系统所创建的索引都创建为本地（或者分区）索引。
Most user-created and system-created indexes are created as local (or partitioned) by default.
A：本地索引不在每个键记录的rowid中存储2字节分区标识符。
A: Local indexes do not store the 2-byte partition identifier in the rowid of each key record.
在多数情况下，本地索引不保留跨分区的顺序属性，如果计划采用本地索引，还需要进行额外的排序操作。
In most cases, local indexes do not preserve the order property across partitions and that requires an extra sort if the plan is using local indexes.
由于每个数据库分区都有它的数据上的本地索引，因此提高了本地数据访问的性能。
Since each database partition has local indexes on its data there is increased performance for local data access.
已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。
Any indexes on the table being attached that match the existing local indexes on the partitioned table can be utilized.
加速数据滚入的最佳实践是，确保在滚入之前，附加表已具有与已分区表上所有本地索引精确匹配的索引。
The best practice to speed up data roll-in is to ensure that, prior to roll-in, the table being attached has indexes that exactly match all local indexes on the partitioned table.
然而，对于本地索引扫描，需要锁定的分区首先要做索引搜索并发现匹配。
However, with local index scans, a partition needs to be locked first to do the index look-up and find a match.
例如，表purchaseorders通过po_date进行了分区，并具有本地索引po_customer，以下查询在完成索引扫描后还需要进行排序。
For instance, the purchaseOrders table is partitioned by po_date and has a local index on po_customer, the query below will need a sort after the index scan.
本地索引更好，因为更好管理，当有数据导入的时候和分区管理操作的时候。
Local indexes are preferable because they are easier to manage during data loads and during partition-maintenance operations.
本地索引可以提供更好的可用性，当表存在分区，子分区管理操作的时候。
Local indexes offer better availability when there are partition or subpartition maintenance operations on the table.
本地索引可以提供更好的可用性，当表存在分区，子分区管理操作的时候。
Local indexes offer better availability when there are partition or subpartition maintenance operations on the table.
应用推荐