The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

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

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