You can translate the question and the replies:

Utilization in Denodo View

1. Can I check how do I know the memory usage in Denodo View? 2. Does the number of columns affect the denodo view memory usage? 3. Is lesser columns selected more feasible for a view?
03-07-2023 03:12:46 -0400

1 Answer

Hi, 1. Currently there's no option to monitor memory usage at view level in Diagnostic & Monitoring tool. Denodo Monitor Report has some info at view level granularity ([by_view]( but they includes only numrows, cache status, execution time, etc.. and no memory information. 2. & 3. Yes, excluding unnecessary columns bring lower memory usage, however it's much more important considering the difference between Streaming and Non-Streaming operators. Non-Streaming ones have the heaviest memory footprint, therefore if you're having memory issue you focus on them. The list of Non-Streaming operation is listed [here]( Also, [this]( section of the VDP administration guide could be useful as it explains some situtation when increasing/decreasing the amount of memory of a Query. Hope this helps
Denodo Team
04-07-2023 09:11:55 -0400
You must sign in to add an answer. If you do not have an account, you can register here