...

select * from admin.connections_detail

Add an index to a cache table

Denodo allows you to add indexes to cache tables for improved performance. However, there appears to be a bug in how Denodo generates/executes the DDL for indexes for existing tables, so if you try to add an index to cache table that already exists, it will fail.

To add an index to a cache table, do the following:

1. Enable caching for a view

2. Add the index under Cache table indexes
   

   Image Added

3. Click Save (you’ll get a warning saying there was issue create the index)

4. Click Recreate cache table

User Guide

Anchor
denodo-user-guide denodo-user-guide

...