每个索引分区仅从相应的数据分区取得索引行。
Each index partition indexes rows only from the corresponding data partition.
每个数据分区的索引分区可以位于不同的表空间中。
The index partition for each data partition can be in a different table space.
Q：我如何知道一个数据分区或者索引分区是否需要重组？
Q: How do I know if a data partition or an index partition needs to be reorganized?
Q：每个分区的本地索引分区和数据分区能否处于同一表空间中？
Q: Can the local index partition and data partition be in the same table space for each partition?
这些计数器由表和索引分区中发生的各个DML操作实现值累加。
These counters are incremented by the respective DML operation occurring on the partition, both table and index partitions.
增加下列结构的有效性：索引或索引分区，表或表分区，索引表。
Validate the structure of an index or index partition, table or table partition, index-organized table.
关于表空间和索引节点组或分区的信息。
Information about the table space and index node groups or partitions.
这个号码将用于作为分区映射的一个索引，以选择那一行所在的数据库分区。
That number is used as an index into the partitioning map to select the database partition for that row.
该命令的输出会展示出每个分区的数据和索引统计信息，并针对需要重组的分区提供建议。
The output will show both the data and index statistics for each partition and recommend which partitions should be reorganized.
如果数据库设计者已在表上创建了主分区索引，那么查询应当与分区列结合。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.
我们不是很乐意使用DPSI，但是我们必须跨多个分区探测多个索引树来寻找行。
We are not so pleased with the DPSI if we must probe multiple index trees to find rows across multiple partitions.
将用于表空间和索引的分区放在单独的DASD卷中，并且，如果可能的话，要隔开控制单元，以减少I/O争用。
Place the partitions for the table space and indexes on separate DASD volumes and (if possible) separate control units in order to minimize I/O contention.
这些建议涉及了数据库模式、XML与关系存储之间的选择、索引的定义以及带有分区和集群选项的物理数据组织。
These recommendations address the database schema, the choice between XML and relational storage, definition of indexes, and physical data organization with partitioning and clustering options.
一个数据库分区由它自己的数据、索引、配置文件和事务逻辑组成。
A database partition consists of its own data, indexes, configuration files, and transaction logs.
在过滤器与提示信息中利用分区和主索引。
Leverage partitions and Primary Indexes in filters and prompts.
如果不为索引或长列指定表空间，分区索引和长列数据会存储在与数据相同的表空间中。
If you don't specify an index or long table space, partitioned indexes and long column data will go in the same table space as the data.
附加的数据分区具有与其数据处于不同表空间中的索引。
The data partition being attached has indexes in a separate table space from the data.
表的主键和所有惟一索引都必须是相关分区键的超集。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
如同其所基于的表一样，本地索引也进行了分区。
Local indexes are partitioned in the same way as the table they are based on.
在多数情况下，本地索引不保留跨分区的顺序属性，如果计划采用本地索引，还需要进行额外的排序操作。
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.
A：索引查找利用全局索引扫描，来确定对分区的引用是否存在。
A: With global index scans, the index look-up determines whether a reference to a partition exists.
对于索引控制的分区方法，分区的表、分区索引和群集这几个概念之间有点纠缠不清。
Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.
现在，DB 2 9.7支持分区索引，允许每个数据分区单独索引。
With DB2 9.7, partitioned indexes are now supported, allowing each data partition to be indexed separately.
对于分区索引，建议选择不大可能改变的键列。
For partitioning indexes, it is recommended that you choose key columns that are unlikely to be changed.
Q：我如何能辨别已分区表上的索引是否被分区？
Q: How can I tell if an index on a partitioned table is partitioned?
加速数据滚入的最佳实践是，确保在滚入之前，附加表已具有与已分区表上所有本地索引精确匹配的索引。
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.
分区号用作分区映射的索引。
The partition number is used as an index into the partitioning map.
然而，对于本地索引扫描，需要锁定的分区首先要做索引搜索并发现匹配。
However, with local index scans, a partition needs to be locked first to do the index look-up and find a match.
因此，在索引对象包含数据分区的全部索引的情况下，指定表空间时，就无法为每个单独的索引指定表空间。
Hence, while you can specify the table space where the index object containing all the indexes for a data partition go, it is not possible to specify a table space for each individual index.
因此，在索引对象包含数据分区的全部索引的情况下，指定表空间时，就无法为每个单独的索引指定表空间。
Hence, while you can specify the table space where the index object containing all the indexes for a data partition go, it is not possible to specify a table space for each individual index.
应用推荐