Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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?

Answers

  • 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
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.