You can translate the question and the replies:

Different execution plans at design studio

Hi, please I want to ask how to get multiple (alternative) execution or query plans at design studio at version 8?

1 Answer

Hi, Generally, when the Denodo Query engine receives a query, before executing it the query engine generates various excution plans and selects the best execution plan for better performace. In order to optimize the execution of queries. I would follow the following optimization methods: * Cost-based optimizations * Simplification of queries * Data movement I am also to configure the execution plan preferences of the Virtual DataPort for a specific query using the CONTEXT clause in the VQL query. **For example:** `Select * from <view_name> context ('simplify'='off')` For more details, you can refer to [Executing Statements](, [CONTEXT Clause]( sections of the Virtual DataPort VQL Guide and [Queries Optimization]( section of the Virtual DataPort Administration Guide. If you still need help and if you are a valid Support User, you may open a Support Case at the Denodo Support Site and the Support Team will help you. Hope this helps!
Denodo Team
07-09-2020 08:31:31 -0400
You must sign in to add an answer. If you do not have an account, you can register here