Latest Activity
HI , usually when we perform a join in two base views or use a subquery in denodo. it creates two different parallel connection to get data from underlying source. can we ensure that both of queries on join run in same session and one after another. be...
We have a complex final view that utilizes many (20+) base views. All of the base views are cached so the query execution plan in very simple. However, in looking at the execution plan we can see that the optimizer is taking 8-9 seconds in query simpli...
Generating statistics for base view is enough or generating statistic for interface views will also improve performance
Hello, supposing the following picture: - I have a Union view (e.g. named U1) based of the Union of 2 views (e.g. T1_S1, T1_S2), each comming from many different oracle data sources (e.g. S1, S2 data sources) - these T1_S1, T1_S2 views are in fac...