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


How to minimize number of projections on a table? — Vertica Forum

How to minimize number of projections on a table?

Are there any techniques/best practices to minimize the number of projections on a table?

Sorting the columns from low to high cardinality in the TABLE DEFINITION can help minimize number of projection on a table?

Comments

  • I would use database designer in order to quickly get optimized projections. You could manually override them later on if needed.

Leave a Comment

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