qua_set_reload_mode

Sets reload mode for given view. Reload mode describes steps to be taken when refreshing the persistent cache.

Syntax

qua_set_reload_mode 'object', 'mode' [;]

Arguments

cache_mode

Fully qualified name of view which incremental marker will be changed.

mode

NVARCHAR(20) mode to be set, with one of the following values:

  • ‘full’ = cache cleaned up and reloaded every time.
  • ‘incremental’ = cache is loaded fully only on initial load, after that only new rows are inserted during reload.

Example

Sets cache mode of view ‘’AdventureWorksDW2012_spark.dbo.DimEmployee’ to ‘incremental’

EXEC qua_set_reload_mode 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'incremental';