About the performance of the query

yamakawayamakawa Vertica Customer

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.

Best Answer


  • yamakawayamakawa Vertica Customer

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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file