Displaying the table index attributes

To display the table index attributes:

Procedure

  1. In the navigation tree, select an index.
  2. The following attributes and their values appear:

    • Name — The name of the index.

    • Metadata UID— The internal UID number of the index.

    • Unique — This attribute specifies whether the index is unique. The value can be Yes or No.

    • Populated— This attribute specifies whether the index is populated. The value can be Yes or No.

    • System Created — This attribute indicates whether the index was created by the system. The value can be Yes or No.

    • Hash Partitioned — This attribute indicates whether the index is partitioned by a hashing key. The value can be Yes or No.

    • Audit Compressed — This attribute indicates whether compressed audit-checkpoint messages are generated for Disk Process 2 (DP2) files. The value can be ON or OFF.

    • Block Size — The length of a block in bytes.

    • Clear On Purge — This attribute indicates whether the disk is erased when the index is dropped. If the value is True, then the contents of the index are overwritten when it is purged. Otherwise the contents are not overwritten.

    • Creation Time — The time and date when the index was created. The time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

    • Redefinition Time — The time and date when the index was last redefined. The time and date are expressed in the yyyy-MM-dd HH:mm:ss.FFFFFF format.

    • Owner— The owner of the index.