Q&A BY TAG 'slow query'

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

How to create a parameterized derived view? Or Is there any way to access a subset of the data(base view) instead of accessing entire table(base view)?
answered 12-06-2018 12:50:33 -0400

I would like to create a derived view (one master base view will join with 3 code lookup base views). It has 5 millions records by Year (2002-2016). When I try to access this view from third party tool like Tableau, it is cripplingly slow and it timed ...

Answers: 1

Parameterize slow query Parameter derived view Tableau

Cached Denodo view is slower than uncached view while fetching data from the tableau.
answered 28-12-2017 13:45:38 -0500

Hi, I have two views in Denodo. One is cached and another one is not cached. Both are having almost 3 crores records and 36 columns. In this scenario, when I fetch records in denodo such as find distinct cloumn in each table, I see it is taking almost...

Answers: 1

slow query