Q&A BY TAG 'optimization'

I have a final UNION view between views with group by that have as data source a CSV file (so there is no database as source). When I execute the query on the union in the execution trace appears that an AGGREGATION PUSH-DOWN was done. But the push do...

static optimization data aggregation Optimization

Hi There, Can denodo send WIth Clause Query as it is to Oracle Data source? Why denodo try to optimize With Clause into SubSQL Query? Can we pass direct With Clause to any data source via denodo ? thanks,

Denodo 8 Oracle Optimization

We are facing a senario where Summary Table Acceleration is not being considered as best plan for execution. We have followed the exact steps available in the Denodo Guide where we are creating a summary table on agreegated transformation. First case,...

summary optimization

Hello dear Denodo team, I have a question regarding the performance of a view based on a MongoDB data source. The base view in question has about 2.7 million records and 256 columns. Running the query SELECT max(date) FROM ; I tried several things...

performance optimization mongodb