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

Create tables partition

Sophie_bdSophie_bd
in General Discussion

Hello,
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,
Sophie

Tagged:

Answers

  • 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
Format
Heading 1Heading 2
QuoteCodeSpoiler
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...

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