We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


Hash segmentation — Vertica Forum

Hash segmentation

Hi,

 

While creating projection we do segmented by hash (col1,col2).

 

What is the rule for taking which columns and how many columns  for better performance ?

 

Can I take all the columns or only the primary key column ?

 

Regards,

Deb

Comments

Leave a Comment

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