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.