Refresh Interval Clause

Reference : Supported SQL Statements and Extensions : Create Cache (EXT) : Refresh Interval Clause

Purpose

The Refresh Interval clause specifies the length of time the data in the cached table can be used before being refreshed; it is optional. The driver maintains a timestamp of when the data in a table was last refreshed. When a cached table is used in a query, the driver checks if the current time is greater than the last refresh time plus the value of Refresh_Interval. If it is, the driver refreshes the data in the cached table before processing the query.

Syntax

[REFRESH_INTERVAL {0 | -1 | interval_value [{M, H, D}]}]

where:

specifies that the cache is refreshed manually. You can use the Refresh Cache statement to refresh the cache manually.

-1

resets the refresh interval to the default value of 12 hours.

interval_value

is a positive integer that specifies the amount of time between refreshes. The default unit of time is hours (H). You can also specify M for minutes or D for days. For example, 60M would set the time between refreshes to 60 minutes.The default refresh interval is 12 hours.