Q&A BY TAG 'Execution plans'

You must sign in to ask a question. If you do not have an account, you can register here

Different execution plans at design studio
answered 07-09-2020 08:31:31 -0400

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

Answers: 1

design studio Execution plans Denodo Query Exceqution Plan

Not able to off the execution plan
answered 18-03-2020 05:51:17 -0400

Hi, I have created a derived view dv1 and on top of that i have created another derived view dv2. Now the problem is i did specify execution plan in dv2 from options tab. But as soon as i off the specify execution plan and open it again it automatic...

Answers: 1

Execution plans

Delegate SQL Sentence as Sub Query not passing to source
answered 23-07-2019 01:57:09 -0400

Hi, I created base view from SQL stored ptocedures. Function have 2 mandatory parameter. When where clause for 2 mandatory field and on additinal field. then manadatory field is filtered by source. But additional field is filtered by Denodo. My Quest...

Answers: 1

subquery Execution plans Stored Procedure derived view

Extracting query with the hardcoded values not parameterized.
answered 29-08-2018 05:33:44 -0400

Hi, Currently we are running a query which has a lot of hard coded values. The query in its execution plan shows up like below Select as column1, as column2 from table; parameters = [<parameter1>, <parameter2>] How can I extract a que...

Answers: 1

query plan Parameterize Query Execution plans Parameter

How associations help to choose best execution plan?
answered 12-03-2018 03:51:51 -0400

Hi there, One of the benefits mentioned in the introduction slide from the Linked Data Associations course (DEN60EDU0134) , mentioned that associations are useful because 'They will be used to optimize queries to increase performance by generating bett...

Answers: 1

associations Execution plans

Different Execution Plans
answered 03-05-2017 08:53:36 -0400

Hi, I have a derived view expecting to run 2 base views parallely and do a join operation in denedo server with the base view results from source server. Even the execution plan in the derived view shows me the same but actual plan is different. On so...

Answers: 1

Execution plans