Displaying information for table index partitions

To display information related to table index partitions:

Procedure

  1. In the navigation tree, select an index.
  2. In the right pane, click Partitions.

    The following details related to table index partitions appear:

    • Partition Number — This is an integer which starts at zero for the main partition and 1 and above for the secondary partitions.
    • System — The name of the NonStop system where this partition is located.
    • Name — This is the name of the partition.
    • File — The physical file where the partition is located.
    • First Key — This specifies the lowest values in the partition for columns stored in ascending order and the highest values in the partition for columns stored in descending order. It is displayed only if the index is range partitioned.
    • Percent Allocated — The percentage of the partition used.
    • Primary Extents — The size of the primary extent in pages.
    • Secondary Extents — The size of the secondary extents in pages.
    • Max Extents — The maximum number of extents.
    • Allocated Extents — The number of extents allocated.
    • Max Size — The maximum size of the partition.
    • Current EOF — The space used in the partition.