When to use Comprehensive and Incremental design? Any use cases?
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: