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.