Latest Activity

code

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?

design studio Execution plans Denodo Query Exceqution Plan

code

Not able to off the execution plan

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...

Execution plans

code

Delegate SQL Sentence as Sub Query not passing to source

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...

subquery Execution plans Stored Procedure derived view

code

Extracting query with the hardcoded values not parameterized.

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...

query plan Parameterize Query Execution plans Parameter

code

How associations help to choose best execution plan?

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...

associations Execution plans

code

Different Execution Plans

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...

Execution plans