Optimizing Queries¶

This section describes different aspects of interest in relation to the optimizing of queries in Virtual DataPort:

• Decreasing the processing time of delimited files: see section Optimizing DF Data Sources.

• Optimizing join operations by selecting the most suitable join method for a view or a query: see section Optimizing Join Operations.

• How the Execution Engine automatically tries to simplify the queries before executing them: see section Automatic Simplification of Queries.

• How the cost-based optimization works and the benefits of enabling it: see section Cost-Based Optimization.

• How the “data movement” optimization can improve the performance of queries that involve a lot of data: see section Data Movement.

• How the “parallel processing” optimization allows Denodo to work with massive parallel processing engines (MPP) to accelerate the execution of queries: see section Parallel Processing.

• How the “data movement” and the “parallel processing” optimization allow Denodo to execute window functions: see section Window Functions.

• How to configure summary views to automatically accelerate queries: see section Smart Query Acceleration Using Summaries.