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
user
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"](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/querying_views/execution_trace_of_a_statement). 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](https://community.denodo.com/docs/html/browse/6.0/vdp/administration/creating_views/importing_data_sources_and_creating_base_views/data_source_configuration_properties) 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