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


What happens if the supplied query file only uses 10 tables of 100 in a schema? — Vertica Forum

What happens if the supplied query file only uses 10 tables of 100 in a schema?

Employee
in General Discussion

If a schema includes 100 tables, the supplied query file only uses only 10 tables. Will DBD exclude the remaining 90 tables from the design, or ignore them?

Tagged:

Answers

  • Vertica Customer ✭

    It depends on the options you pick. You can choose between a comprehensive or incremental design. If you choose comprehensive, it will supply suggested projections for all tables in a schema. If you already have projections on your tables and data loaded and are looking to get suggestions for better or query-specific projections, select incremental design. This option will then only suggest projection designs for the tables involved in the supplied queries.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
You can use Markdown in your post.
Home • General DiscussionComment As ...