qua_switch_view_copy

Switches view copy between the primary and secondary table for cached views with two rotated tables.

The procedure is called internally by qua_full_load_cached_view_copy just after the secondary copy was loaded. Note that this procedure does not execute any data load or cache eviction.

Syntax

qua_switch_view_copy 'view_name' [;]

Arguments

‘view_name’

Fully qualified name of view which status will be affected.

Example

Switches between primary and secondary cache copy for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_switch_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee';