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


why does incremental DBD proposes existing projections — Vertica Forum

why does incremental DBD proposes existing projections

Hello
I have several new developments, using common master data tables with different fact tables.
Each time I run an incremental DBD for new queries about the new fact tables, I get proposals for projections on the MD tables, and most of the time these projections already exist (same encoding, same column list, same order) !
How comes that Vertica DBD is not able to identify existing similar projections structures in the DB ?
From the doc found on Vertica website "- Incremental—Customers can optionally create additional projections that optimize new queries without disturbing the existing physical design" ... Here it is not really "additional"
I always need to check all the projections to avoid duplication !
Thanks for your support

Isabelle

Leave a Comment

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