Purpose

The Refresh Cache statement forces the data in the cache for the specified remote table to be refreshed.

Syntax

REFRESH CACHE ON {remote_table | ALL}

where:

remote_table
is the name of the remote table cache to be refreshed. The remote table name can be a two-part name: schemaname.tablename. When specifying a two-part name, the specified remote table must be mapped in the specified schema, and you must have the privilege to insert, update, and delete objects in the specified schema.
ALL
forces all caches to be refreshed.

Notes

  • Caches on views are not supported.