Q&A BY TAG 'VDP query optimisation'

You must sign in to ask a question. If you do not have an account, you can register here

how can we ensure in a join /subquery a query passed to underlying source first then another one in a same session
answered 06-01-2020 17:40:44 -0500

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

Answers: 1

query execution VDP query optimisation

Denodo query simplification taking a long time.
answered 01-07-2019 21:15:17 -0400

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

Answers: 1

VDP query optimisation

Do we need to generate the statistics for Interface views
answered 07-12-2016 05:41:51 -0500

Generating statistics for base view is enough or generating statistic for interface views will also improve performance

Answers: 1

view VDP query optimisation interface Generate stats

Is it possible to force a SQL Query distribution on each datasource, when there is an Union view ?
answered 13-04-2016 13:05:50 -0400

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

Answers: 1

VDP query optimisation