Cost Based Optimization¶

The Denodo cost-based optimization process needs the statistics of at least all the base views involved in the query (the average size of a field, the maximum and minimum values, the number of distinct values, etc.) to estimate the cost of possible execution plans.

Statistics allow Denodo to decide whether to apply optimizations such as join reordering, choosing a join execution method (merge, hash, nested,…), applying ‘aggregation pushdown’, or performing data movement automatically.

It is therefore strongly recommended to gather statistics for each base view created in the Denodo Embedded MPP data source.