示例:创建已分区表和已分区索引。
Example: Create a partitioned table and a partitioned index.
对于分区索引,建议选择不大可能改变的键列。
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.
对一个分区索引来说,每个分区都有一个单独的索引段来容纳数据。
For a partitioned index, every partition has a single index segment to hold its data.
在分析现有空间索引方法特点的基础上,设计了一种分区索引文件方法。
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.
关于表空间和索引节点组或分区的信息。
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.
我们不是很乐意使用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.
一个数据库分区由它自己的数据、索引、配置文件和事务逻辑组成。
A database partition consists of its own data, indexes, configuration files, and transaction logs.
在过滤器与提示信息中利用分区和主索引。
Leverage partitions and Primary Indexes in filters and prompts.
每个索引分区仅从相应的数据分区取得索引行。
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.
表的主键和所有惟一索引都必须是相关分区键的超集。
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.
Q:我如何知道一个数据分区或者索引分区是否需要重组?
Q: How do I know if a data partition or an index partition needs to be reorganized?
应用推荐