You can explore all of these options on your own by right-clicking on the schema object (a table, view, index, or schema) to see which options are available for that particular object.
您可以通过在模式对象(表、视图、索引或模式)上单击右键自己探索这些选项,看看对于特定的对象有哪些可用的选项。
This differs from global indexes where each global index has its own object, allowing greater flexibility in table space placement and support for REORG for an individual global index.
这不同于全局索引,每个全局索引有自己的对象,其提供灵活的表空间定位能力,并支持单个全局索引REORG操作。
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 BTYPE column identifies the object type: 'T' for table, 'I' for index, and 'F' for function instance.
BTYPE列显示对象类型:'T' 表示表,'I' 表示索引,'F' 表示函数实例。
A large table space named USERSPACE1, which is used to store all user-defined objects along with table data, index data, large object (LOB) data, and long value data.
一个名为userspace1的大表空间,用于存储所有用户定义对象,以及表数据、索引数据、大对象(LOB)数据和长值数据。
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.
索引也是一种DB 2对象(一个单独的VSAM数据集),它由一组排好序的键组成,这些键是从相应表中的一个列或多个列抽取出来的。
Besides reorganizing one or more indexes, large object data types (LOBs) that are contained in the clustered index or underlying table are compacted by default when an index is reorganized.
重新组织索引时,除了重新组织一个或多个索引外,默认情况下还将压缩聚集索引或基础表中包含的大型对象数据类型(lob)。
For example, when you add a new index, you must modify the object definition to specify the table to which the index applies before the index definition is valid.
例如,当您加入新的索引时,必须先修改物件定义来指定套用此索引的资料表,该索引定义才会变成有效。
For example, when you add a new index, you must modify the object definition to specify the table to which the index applies before the index definition is valid.
例如,当您加入新的索引时,必须先修改物件定义来指定套用此索引的资料表,该索引定义才会变成有效。
应用推荐