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.