对于分区索引，建议选择不大可能改变的键列。
For partitioning indexes, it is recommended that you choose key columns that are unlikely to be changed.
现在，DB 2 9.7支持分区索引，允许每个数据分区单独索引。
With DB2 9.7, partitioned indexes are now supported, allowing each data partition to be indexed separately.
IndexTSName：指定存储每个数据分区的分区索引的表空间。
IndexTSName: Identifies the table space in which the partitioned index for each data partition is to be stored.
IndexTSName：标识表空间，其中存储新分区的任何分区索引。
IndexTSName: Identifies the table space in which any partitioned indexes for the new partition are to be stored.
如果数据库设计者已在表上创建了主分区索引，那么查询应当与分区列结合。
If the database designer has created a Primary partition Index on a table, queries should incorporate the partitioning column.
在分析现有空间索引方法特点的基础上，设计了一种分区索引文件方法。
Based on the analysis of the current spatial index method characteristics, a kind of partition index file method is designed.
对于索引控制的分区方法，分区的表、分区索引和群集这几个概念之间有点纠缠不清。
Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.
为了使用这种技术，SQL必须提供分区索引的第一个键列上的一个谓词。
In order to use this technique, the SQL must provide a predicate on the first key column of the partitioning index.
如果不为索引或长列指定表空间，分区索引和长列数据会存储在与数据相同的表空间中。
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.
全局范围分区索引的最后一个分区必须使用MAXVALUE设置一个分区边界。
The highest partition of a global index must have a partition bound, all of whose values are MAXVALUE.
用户不能向全局范围分区索引中添加分区，因为最后一个分区总是以MAXVALUE 作为分区边界。
You cannot add a partition to a global index because the highest partition always has a partition bound of MAXVALUE .
你可以创建一个压缩索引，或者重建时压缩一个索引(尽管对在线重建、重建分区索引等有一些限制)。
You can create an index as compressed, or rebuild it to compress it although there are some restrictions about online rebuilds, rebuilds of partitioned indexes etc.
这个号码将用于作为分区映射的一个索引，以选择那一行所在的数据库分区。
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.
我们不是很乐意使用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.
由于每个数据库分区都有它的数据上的本地索引，因此提高了本地数据访问的性能。
Since each database partition has local indexes on its data there is increased performance for local data access.
因此，在利用本地索引进行访问时，那些行与查询处理无关的分区仍被锁定。
Therefore, some partitions that do not contribute any rows for query processing are still locked when accessed via local index.
每个索引分区仅从相应的数据分区取得索引行。
Each index partition indexes rows only from the corresponding data partition.
表的主键和所有惟一索引都必须是相关分区键的超集。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
在多数情况下，本地索引不保留跨分区的顺序属性，如果计划采用本地索引，还需要进行额外的排序操作。
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.
已分区表上的任何与现有本地索引相匹配的、附加在该表上的索引都可用。
Any indexes on the table being attached that match the existing local indexes on the partitioned table can be utilized.
Q：我如何知道一个数据分区或者索引分区是否需要重组？
Q: How do I know if a data partition or an index partition needs to be reorganized?
加速数据滚入的最佳实践是，确保在滚入之前，附加表已具有与已分区表上所有本地索引精确匹配的索引。
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.
因此，在索引对象包含数据分区的全部索引的情况下，指定表空间时，就无法为每个单独的索引指定表空间。
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.
应用推荐