Optimize Denodo views

• Overview
• Use caching
• Examine the data lineage
• Change the execution plan

Overview

When using Denodo for data virtualization and integration, you may be able to improve the performance of Denodo views. For potential options, see below.

Use caching

In Denodo at IU, caching is not performed at the server level. Instead, each virtual database (VDB) is configured with an exclusive Oracle tablespace for caching. Developers have sufficient permissions to manage partial caching at the view level.

If you want to use full caching, fill out the EDSD Support Form to request access to the Denodo scheduler. To learn more about caching, see the Denodo Agile performance tutorial.

Examine the data lineage

You can examine your data lineage for a derived view by using Tree View. If you are combining data that you don't need, consider redesigning your derived view.

Change the execution plan

You can change how Denodo executes complex joins by modifying the execution plan. For details, see the Denodo Virtual DataPort Administration Guide. If you wish to try data movement, your cache tablespace is exclusive to your VDB and available for your use.