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

MichaelJKMichaelJK 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

  • JoeGonzalezVertDBAJoeGonzalezVertDBA 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
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...