You can translate the question and the replies:

Denodo Union Performance issue

Hi Team, I have a base view "A" from DB1 and one more base view "B" from DB2 I am doing union in Denodo getting "C". while I am excuting "C" for one applicationid, it is taking more than 10 seconds to fetch the data, my original base views "A" and "B" is taking less than 2 seconds for same application id but when we execute union View(Union of A and B) at Denodo is taking more than 10 seconds to retreive 1 record so is there a way to improve the performance. PS : The A and B Base views has just 1 additonal column at Denodo which multiplies 2 columns. Regards Mohan
01-03-2018 15:22:59 -0500

1 Answer

Hi, I think the view "C" is not delegating the filter condition to the datasource, so I suggest to take a look to the ["Execution trace of the query"]( There you can see if the filter condition is being delegated. If the filter condition is not delegated to the source, you can review the [configuration of your datasources]( to check why this happens and to see if it's possible to delegate this operation to that kind of source. Hope this helps!
Denodo Team
02-03-2018 08:10:01 -0500
You must sign in to add an answer. If you do not have an account, you can register here