Skip to main content
Question

Create tables partition

  • Dec 21, 2021 8:43 AM UTC
  • 1 reply
  • 7 views

Sophie_bd

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

1 reply

Jim_Knicely
Forum|alt.badge.img+2
  • Participating Frequently
  • Dec 21, 2021 1:53 PM UTC

@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!