Materialized view partition properties

  • Partition Number

    The index number of the partition.

  • System

    The name of the NonStop system where the partition is located.

  • Name

    The partition name. It is either system or user created.

  • File

    The name of the physical file where the partition is located.

  • First Key

    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 table is range partitioned.

  • Percent allocated

    The percentage of the partition allocated to the MV.

  • Primary Extents

    The size, in pages, of the primary extents.

  • Secondary Extents

    The size, in pages, of the secondary extents.

  • Max Extents

    The maximum number of extents in the partition.

  • Allocated Extents

    The number of extents allocated in the partition.

  • Max Size

    The maximum size of the partition.

  • Current EOF

    The space used in the partition.