Individual piece of a non-partitioned index.
非分区索引的单个索引。
This view supports parallel partitioned index scans.
此视图支持并行分区索引扫描。
Example: Create a partitioned table and a partitioned index.
示例：创建已分区表和已分区索引。
For a partitioned index, every partition has a single index segment to hold its data.
对一个分区索引来说，每个分区都有一个单独的索引段来容纳数据。
IndexTSName: Identifies the table space in which the partitioned index for each data partition is to be stored.
IndexTSName：指定存储每个数据分区的分区索引的表空间。
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.
如果不为索引或长列指定表空间，分区索引和长列数据会存储在与数据相同的表空间中。
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.
你可以创建一个压缩索引，或者重建时压缩一个索引(尽管对在线重建、重建分区索引等有一些限制)。
When creating a partitioned table space in DB2 UDB V7, DB2 divides the data among the partitions according to the part clause of the CREATE INDEX statement.
在DB 2UDBV 7中创建分区的表空间时，DB 2根据CREATEindex语句的part子句将数据划分到几个分区上。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时，当创建分区的表时，分区的边界由CREATEtable语句决定，而不是由CREATEindex语句决定。
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.
例如，表purchaseorders通过po_date进行了分区，并具有本地索引po_customer，以下查询在完成索引扫描后还需要进行排序。
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.
发生这一问题的原因在于数据库内的索引锁定或锁存(例如事务处理日志周围的索引锁定或锁存)，直到该应用程序使用分区数据库为止。
Q: How do I calculate the table and index size for a partitioned table (or any table for that matter)?
Q：如何计算已分区表（或者任何相关的表）的表大小和索引大小？
Under index-controlled partitioning, the concepts of partitioned table, partitioning index and clustering were all intertwined.
对于索引控制的分区方法，分区的表、分区索引和群集这几个概念之间有点纠缠不清。
Q: How can I tell if an index on a partitioned table is partitioned?
Q：我如何能辨别已分区表上的索引是否被分区？
The impact of a data-partitioned secondary index (DPSI) structure on ORDER BY sort avoidance.
一个分区数据二级索引(data - partitioned secondary index,DPSI)结构对ORDERBY排序规避的影响。
Starting in DB2 Version 9.7 Fix Pack 1, you can create an index over XML data on a partitioned table as either partitioned or nonpartitioned.
从DB2Version 9.7FixPack1 开始，在分区的表上创建的XML数据索引可以是分区的，也可以是不分区的。
Those interested in this can read the white paper Partitioned Table and Index Strategies Using SQL Server 2008.
对此感兴趣的读者可以阅读白皮书《使用SQL Server 2008的分区表和索引策略》。
If the table or index is partitioned, each partition is stored in its own segment.
如果这个表或者索引被分区，那么每个分区会被存储在它自己的拥有的段中。
A rectangular region of geography is roughly partitioned in several times to multilevel sub-regions, in which spatial index of R-tree has been constructed.
该方案首先将矩形地理空间进行租网格划分建立多级网格索引，然后针对每个小网格建立基于R树的空间索引。
A rectangular region of geography is roughly partitioned in several times to multilevel sub-regions, in which spatial index of R-tree has been constructed.
该方案首先将矩形地理空间进行租网格划分建立多级网格索引，然后针对每个小网格建立基于R树的空间索引。
应用推荐