The utilization of the view cache can be controlled by the following hints:įorce utilization of view cache if availableįurther special hints like RESULT_CACHE_MAX_LAG, RESULT_CACHE_NON_TRANSACTIONAL, RESULT_CACHE_NO_REFRESH, RESULT_LAG, RESULT_CACHE_AFTER_ANALYTIC_PRIVILEGE and RESULT_CACHE_BEFORE_ANALYTIC_PRIVILEGE are described in the SAP HANA documentation. In what way the view cache can be used by a query? The cache entry is rebuilt with the next access.Ħ. With the specified the view cache entry is removed. With the specified the view cache entry is refreshed. Every change to an underlying table will result in an immediate cache refresh if minutes is set to 0 or not specified.Īdditional options like a projection list or filter conditions can be used.Īll view cache entries are removed globally.įor the specified object the view cache is refreshed.
defines a change that needs to be reflected in the cache at latest after how many minutes.
įor a specific object these commands allow activating the view cache. The following commands can be used to administer the view cache:ĬREATE FUNCTION. In what way the view cache can be administered? View cache has the following limitations:Īs of SAP HANA SPS 11 it is available 5. The following advantages can be provided by the view cache: In the underlying tables limited amount of changesģ.In the following scenario the view cache is particularly helpful: This allows quick data retrieval without repeating overhead like search and aggregation. To cache results on SQL views, calculation views and CDS views the SAP HANA view cache (or result cache extension) is used.
0 kommentar(er)
