Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Create tables partition

I have searched for some ways to optimize request-response.
After creating Projection I think to create Partition on my FACT tables, on one functional column that contains data it can be partitioned.
My configuration is one database on 3 nodes.

Best regards,


  • Jim_KnicelyJim_Knicely Administrator
    edited December 2021

    @Sophie_bd - Is there a question in your post? :) Are you asking why a column can't be partitioned?

    If so, read through the "Partitioning Requirements and Restrictions" section of the doc here: Partition Clause.

    If you have any questions, let us know!

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.