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

Arvind_Kumar

tuning_parameter       | INSERT /*+ DIRECT */ INTO table_A  SELECT * FROM table_b

tuning_description     | consider incremental design on query

 

 

when i get consider incremental design on query 

how i can improve it the query INSERT /*+ DIRECT */ INTO table_A  SELECT * FROM table_b

 

 

what is incremental design means?

SruthiA

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