Each index partition indexes rows only from the corresponding data partition.
每个索引分区仅从相应的数据分区取得索引行。
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.
在分析现有空间索引方法特点的基础上，设计了一种分区索引文件方法。
The output will show both the data and index statistics for each partition and recommend which partitions should be reorganized.
该命令的输出会展示出每个分区的数据和索引统计信息，并针对需要重组的分区提供建议。
The index partition for each data partition can be in a different table space.
每个数据分区的索引分区可以位于不同的表空间中。
A: With global index scans, the index look-up determines whether a reference to a partition exists.
A：索引查找利用全局索引扫描，来确定对分区的引用是否存在。
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.
因为只在新附加分区上构建这一本地索引，并需要非常有限的日志，所以与全局索引相比，SETINTEGRITY甚至明显变快了。
Q: Can the local index partition and data partition be in the same table space for each partition?
Q：每个分区的本地索引分区和数据分区能否处于同一表空间中？
However, with local index scans, a partition needs to be locked first to do the index look-up and find a match.
然而，对于本地索引扫描，需要锁定的分区首先要做索引搜索并发现匹配。
These counters are incremented by the respective DML operation occurring on the partition, both table and index partitions.
这些计数器由表和索引分区中发生的各个DML操作实现值累加。
You just need to realize that we have been warned about the negatives of DPSIs in cross-partition processing, including the multiple index probes needed for sort avoidance.
您只需要认识到，我们一直警告关于跨分区处理DPSI的负面效应，包括规避排序所需的多个索引。
Therefore, it can use Partition 1 of our index the traditional way to avoid a sort on ZIPCODE.
因此，它可以以传统方法使用我们索引的Partition1来避免在ZIPCODE上进行排序。
Now, when creating partitioned tables, the partition boundaries are determined by the CREATE table statement instead of CREATE INDEX.
这时，当创建分区的表时，分区的边界由CREATEtable语句决定，而不是由CREATEindex语句决定。
The partition level INDEX in clause is specified in the CREATE TABLE statement, or.
语句createTABLE中指定了分区级别的INDEXin子句，或者。
The replay position advancement is necessary because the slow alter, alter fragment, and clustered index creation operations change the table partition Numbers.
重放位置的推进是必需的，因为slowalter、alterfragment和集群索引创建操作会改变表分区号。
The main advantage of sitemap index files is, of course, a means to partition sitemap files of very large Web sites into smaller chunks.
当然，站点索引文件的主要优势就是能把非常大的Web站点的站点文件分割成众多比较小的文件。
IndexTSName: Identifies the table space in which the partitioned index for each data partition is to be stored.
IndexTSName：指定存储每个数据分区的分区索引的表空间。
Generally, after a redistribution of a database partition group, you need to perform an offline table reorg, index recreation (if necessary), and runstats on the redistributed table.
通常，在数据库分区组重分发之后，需要在重分发的表上执行离线的table reorg、indexrecreation(必要时)和runstats。
That number is used as an index into the partitioning map to select the database partition for that row.
这个号码将用于作为分区映射的一个索引，以选择那一行所在的数据库分区。
Q: How do I know if a data partition or an index partition needs to be reorganized?
Q：我如何知道一个数据分区或者索引分区是否需要重组？
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.
因此，在索引对象包含数据分区的全部索引的情况下，指定表空间时，就无法为每个单独的索引指定表空间。
The partition number is used as an index into the partitioning map.
分区号用作分区映射的索引。
The first performance of double wave shutter partition comfort, we use comfort index to sum up.
双波百叶隔断的第一个性能舒适度，我们用舒适度指数来进行总结。
Louver partition has the objective conditions to quantify, has reached the best human body principle, can control the comfort index.
百叶隔断具有把这些客观条件进行量化，已达到人体最佳为原则，能够控制这个舒适度指数。
A: Yes, in fact this is the default case and many customers choose to do so. The local index will be in a different table space from the associated data partition when.
A：可以，事实上默认情况下就是如此，并且很多用户都会选择这样做。
Cannot have global partition with bitmap type index. The partition will be set to default.
不能使用带有位图类型索引的全局分区。该分区将被设置为默认值。
The highest partition of a global index must have a partition bound, all of whose values are MAXVALUE.
全局范围分区索引的最后一个分区必须使用MAXVALUE设置一个分区边界。
The highest partition of a global index must have a partition bound, all of whose values are MAXVALUE.
全局范围分区索引的最后一个分区必须使用MAXVALUE设置一个分区边界。
应用推荐