cancel
Showing results for 
Search instead for 
Did you mean: 

Missing attribute 'p#' in meta of partition column in partition table

k-mambo
New Contributor II

.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?

 

 

2 REPLIES 2

nugend
New Contributor II

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.

k-mambo
New Contributor II

For query performance, is it right that there should be additional attributes for time and symbol columns in addition to the partition column?