qua_set_view_cache_mode

Sets the cache mode for given view. For persistent tables default persistent table names are used. No partitioning is defined for caches.

Syntax

qua_set_view_cache_mode 'view_name', 'cache_mode' [;]

Arguments

view_name

Fully qualified name of view which cache mode will be changed.

cache_mode

TINYINT with one of the following values:

Value

Meaning

0

No caching

1

Caching in Spark in-memory

3

Single persistent table caching

4

Two persistent rotated tables caching

5

Single persistent table + in-memory caching

6

Two persistent rotated tables + in-memory caching

Example

Sets in-memory caching for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_set_view_cache_mode @view_name = 'AdventureWorksDW2012_spark.dbo.DimEmployee', @cache_mode = 1;