.Q.PV results confirm that the partitions are sequential.
The partition table is properly verified as a result of .Q.pt.
However, if you check the meta information in the partition table, the Parted attr in the partition column is not displayed.
I wonder if there are any performance issues even if the attributes are not displayed.
If so, what action should I do?
Be aware that the p attribute is not directly correlated with whether a table is partitioned or not. A table being partitioned refers to the fact that it stored inside multiple partition directories within the database. A column having the p attribute means that the data in the column is ordered in contiguous, unique blocks.
You will at least have to update the columns with the p attribute manually and you may have to re-sort the data in each of the partitions for the table.
Tel: +44 (0)28 3025 2242
Tel: +1 (212) 447 6700
Tel: +61 (0)2 9236 5700