About the performance of the query

yamakawa

We are currently in the process of implementing a new Vertica for the system upgrade.
There is a group of tables in the existing system that holds data as follows.
Table 01: Data as of 01/01/2020
Table 02: Data as of 12/01/2019
...
Table 13: Data as of 01/01/2019
(All the same table definition)

When using the data, the above tables are combined to obtain the data.

Now, the above tables have been merged into a single table and
I'm thinking of adding unique key to indicate the date.

From the point of view of those who are familiar with Vertica, which of the following methods can be expected to improve speed more?
Multiple tables, as at present.
Combine them into a single table.

We look forward to hearing from you.

qinchaofeng

Is there a date column in your table?
If there is, you can partition by month according to the amount of data.

yamakawa

Thank you for your response.
I'm going to try the method of storing data in one table and creating a partition.