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';