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?
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.
Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.