[WorkLoad Analyser]-what is "consider incremental design on query"

In vertica, there are mainly 2 design types

1) Comprehensive: Using the Database Designer, a comprehensive design creates a complete initial or replacement design. If you have reasonably representative data, you can create a comprehensive design that is optimized for storage and load. If you provide queries, the design is optimized for those queries.

2) Incremental: An incremental design creates an enhanced design with additional projections, if required, that are optimized specifically for the queries that you provide. Create an incremental design when you have one or more queries that you want to optimize.

Please visit the following URL to know more about design types

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/AdministratorsGuide/ConfiguringTheDB/PhysicalSchema/DBD/DesignTypes.htm%3FTocPath%3DAdministrator's%2520Guide%7CConfiguring%2520the%2520Database%7CCreating%2520a%2520Database%2520Design%7CSpecifying%2520Parameters%2520for%2520Database%2520Designer%7CDesign%2520Types%7C_____0

Please run DBD from admintools and choose incremental design type, provide sample queries (used most often) as input to DBD, it will optimize the design. Please visit below URL on how to run DBD from admintools

https://my.vertica.com/docs/7.1.x/HTML/index.htm#Authoring/GettingStartedGuide/UsingDatabaseDeisgner/RunningDBDwithAT.htm?Highlight=incremental design