...

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 failDenodo where index creation will succeed on the DB-side but Denodo will throw an error or warning. While this warning can be ignored when creating indexes in Design Studio, it can cause schedule cache jobs to fail if a PK index needed to be created as part of the job (invalidating rows based on PK enabled). To get around this, simply create the indexes in Design Studio before running the job.

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)
   Click Recreate cache table

   Image Added

User Guide

Anchor
denodo-user-guide denodo-user-guide

...