In the previous section, you activated the cache module in your Denodo server. Now, you need to configure your views to make use of the cache.
For example, let's activate the cache in the client_with_bills view. We have two main reasons to select this view as a cached view:
Please, follow these steps:
Cache mode:, check
Partial. It will enable a partial cache for the client_with_bills view.
Now test if the cache works as expected by performing the following test:
Tools > VQL Shell.
SELECT * FROM client_with_bills TRACE
Execution Tracebutton (above the results) to see the query execution plan. You can see that the data comes directly from the different data sources.
Executeand perform the same query again.
Execution Tracebutton again and you will see that the data comes from the cache (displayed with a box a icon), and the execution time of the query is faster.
In the next section, you will learn more about the available cache modes. In the above example, you configured the view to use Partial mode, in the next section we will learn the the behavior of the different cache modes.