You can translate the question and the replies:

Optimization in denodo

Is there any option in denodo like SQL developer (Query optimizer option) if I supply an sql ,denodo will be showing the areas of improvement for that sql on areas of performance . For example if the query is a taking a specific plan and if the same query can go through different query plan the data retrieval will be faster . Also if I am having multiple passes for the particular query if I make some changes I can reduce the passes and make the data retrieval will be faster
user
16-05-2019 06:46:20 -0400

1 Answer

Hi, Denodo engine provides a sophisticated query optimizer. To enable the static and/or dynamic query optimizations you can go to the server configuration and go to the queries optimization tab. You can choose to turn all the possible optimization. You can find some more details about the types of query optimization in the link below: https://community.denodo.com/docs/html/browse/7.0/vdp/administration/server_administration_-_configuring_the_server/queries_optimization/queries_optimization To check which query optimization has been applied to the query, you can go to the execution trace and click on the execution plan. You can refer to this document for more details https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_derived_views/querying_views/execution_trace_of_a_statement To know more on optimization and it’s best practices I would suggest you go through the links below https://community.denodo.com/kb/view/document/Best%20Practices%20to%20Maximize%20Performance%20I:%20Modeling%20Big%20Data%20and%20Analytic%20Use%20Cases?category=Best+Practices https://community.denodo.com/kb/view/document/Best%20Practices%20to%20Maximize%20Performance%20II:%20Configuring%20the%20Query%20Optimizer?category=Best+Practices You can also take a test drive to learn more about optimization and have some hands-on using this link below https://www.denodo.com/en/denodo-platform/test-drives/analytics-aws Hope this helps!
Denodo Team
17-05-2019 21:20:26 -0400
You must sign in to add an answer. If you do not have an account, you can register here