Updating Cache Control Columns¶

Since Denodo 9.4 the cache tables can be created to not use status control columns. The ALTER TABLE sentence can be used to update the cache control columns of a view configured with “Full” materialization.

The syntax for ALTER TABLE to revert back the cache table to use status control columns is:

ALTER VIEW sampleView
CACHE ADD CONTROL_COLUMNS [ ALLOW_RECREATION | FORCE_RECREATION ]

The syntax for ALTER TABLE to update the cache table to not use status control columns is:

ALTER VIEW sampleView
CACHE REMOVE CONTROL_COLUMNS [ ALLOW_RECREATION | FORCE_RECREATION ]

By default the sentences will not recreate the cache table and a failure will be thrown if the cache table can not be updated without losing data.

The ALLOW_RECREATION option will allow the cache table to be recreated if necessary so no error will be thrown.

The FORCE_RECREATION option will force the cache table to be recreated with the new schema.