qua_trim_view_copy

qua_trim_view_copy#

Drops persistent cache and recreates it. Can be used only with views that have a persistent cache configured. Secondary cache option is available only for a persistent cache with rotated tables. Internally uses qua_create_view_copy.

Syntax#

qua_trim_view_copy 'view_name', 'copy' [;]

Arguments#

view_name

Fully qualified name of view which data will be affected.

copy

SYSNAME that can be one of two values: ‘primary’ or ‘secondary’.

Example#

Drops and recreates primary cache copy for AdventureWorksDW2012_spark.dbo.DimEmployee.

EXEC qua_trim_view_copy 'AdventureWorksDW2012_spark.dbo.DimEmployee', 'primary';