索引也是一种DB 2对象(一个单独的VSAM数据集),它由一组排好序的键组成,这些键是从相应表中的一个列或多个列抽取出来的。
An index is a DB2 object (a separate VSAM dataset) that is comprised of an ordered set of keys extracted from one or more columns of the corresponding table.
表的主键和所有惟一索引都必须是相关分区键的超集。
The primary key and any unique index of the table must be a superset of the associated partitioning key.
这样将至少为索引可以基于中间页中的键集拥有的最大大小的一行留出足够的空间。
This leaves sufficient space for at least one row of the maximum size that the index can have, based on the set of keys on the intermediate pages.
应用推荐