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


Projection design — Vertica Forum

Projection design

I need to design the projection in such a way that the join between a fact table and multiple dimension tables simultaneously works fast. Pre-join projection is not an option as merge operation is happening during load of tables. Also co-segmenting and co-ordering can be done only for one pair of tables at a time. Please help.

Comments

  •   Take the query you are running and go thru the DBD using incremental option where you suply the DBD with your query.

      You will end up with some optimized projection for your query.

     

  • Hi Adrian,

     

    Thanks for your response. But what I intend to understand is the concept that would be applied to create a solution of this problem. Any explanation in this regard would be very helpful.

     

    Thanks

  • Can't uderstand "Also co-segmenting and co-ordering can be done only for one pair of tables at a time." why?

    You can create multiple projection for each join operation. Did you try it?

Leave a Comment

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