Default Refresh Age (dft_refresh_age)

Configuration Type
Database

Parameter Type
Configurable

Default [Range]
0 [ 0, 99999999999999 (ANY)]

This parameter has the default value used for the REFRESH AGE is the CURRENT REFRESH AGE special register is not specified. This parameter specifies a time stamp duration value with a data type of DECIMAL(20,6). This time duration represents the maximum duration since a REFRESH TABLE statement has been processed on a specific REFRESH DEFERRED summary table during which that summary table can be used to optimize the processing of a query. If the CURRENT REFRESH AGE has a value of 99999999999999 (ANY), and the QUERY OPTIMIZATION class is five or more, REFRESH DEFERRED summary tables are considered to optimize the processing of a dynamic SQL query.