2022.04.26 03:01 PM
.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?
2022.04.26 05:18 PM
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.
2022.04.26 06:35 PM
For query performance, is it right that there should be additional attributes for time and symbol columns in addition to the partition column?
EMEA
Tel: +44 (0)28 3025 2242
AMERICAS
Tel: +1 (212) 447 6700
APAC
Tel: +61 (0)2 9236 5700
KX. All Rights Reserved.
KX and kdb+ are registered trademarks of KX Systems, Inc., a subsidiary of FD Technologies plc.