HP Integrity NonStop J-Series - Manual (Page 60)

2. In the right pane, click Attributes.
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 available values are
Yes or No .
•
Populated: — This attribute specifies whether the index is populated. The available values
are
Yes or No .
•
System Created: — This attribute indicates whether the index was created by the system.
The available values are
Yes or No .
•
Hash Partitioned: — This attribute indicates whether the index is partitioned by a hashing
key. The available values are
Yes or No .
•
Audit Compressed: — This attribute indicates whether compressed audit-checkpoint
messages are generated for Disk Process 2 (DP2) files. The available values are
ON or
OFF .
•
Block Size: — The length of a block in bytes.
•
Clear On Purge: — This attribute indicates whether the disk the erased when the index
is dropped. The available values are
ON or OFF .
•
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.
Viewing the DDL output for a table index
To view the DDL output for a table index:
1.
In the navigation tree, select the index.
2. In the right pane, click DDL.
The DDL tab displays the SHOW DDL output for the index. For more information on the SHOW
DDL command, see the HP NonStop SQL/MX Release 3.2 Reference Manual.
Viewing information related to table index partitions
To view information related to table index partitions:
1.
In the navigation tree, select the index.
60 Viewing database objects