Contents

qua_full_load_cached_view_copy

Loads cache for given view. Handles all modes of caches changes cache status appropriately as load progresses. For persistent rotated tables cache, switches current after the load is done. Internally it uses many other stored procedures and orchestrates them depending on given view’s cache mode.

Syntax

qua_full_load_cached_view_copy 'view_name' [;]

Arguments

‘view_name’

Fully qualified name of view which cache will be affected.

Example

Loads cache for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_full_load_cached_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee';

qua_evict_spark_inmem_cached_table qua_full_load_view_copy