The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

Comprehensive vs Incremental Design

nkarkarenkarkare
in General Discussion

When to use Comprehensive and Incremental design? Any use cases?

Comments

  • TomMTomM

    Hi. I know I've mentioned this before, and our Vertica Essentials training covers this topic nicely. https://inter.viewcentral.com/events/cust/catalog.aspx?cid=arcsight&pid=1&lid=2&bu_id=6

    The standard use case for comprehensive is after you've stood up your cluster and loaded a reasonably representative amount of data.

    The standard use case for incremental is you have a query (or two) that you must optimize.

    The best things I've learned about the DBD are:

    • You MUST run it - it's that important
    • You MUST supply it / point it at as much of your data as possible
    • You MUST give it a good set of representative queries
    • It's NOT one and done. In other words you'll want to run this / re-visit it over time. As you continue to load data your schemas will grow and the underlying data changes. As you add users they will create new queries and do things that will most likely require an updated database design..

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