Use Model Administration Tool to Automatically Purge the Cache for Specific Tables

Purging the cache deletes entries from the query cache and keeps your content fresh. You can automatically purge cache entries for specific tables, by setting the Cache Persistence Time field for each table in Model Administration Tool.

Note:

If you use Semantic Modeler, see What Are a Physical Table's General Properties?

This is useful for data sources that are updated frequently. For example, if you have a table that stores stock ticker data that is updated every minute you can use the Cache Persistence Time setting to purge the entries for that table every 59 seconds. See Cache and Cache Persistence Timing for Specified Physical Tables.