SET_DEPOT_ANTI_PIN_POLICY_PROJECTION
Assigns the highest depot eviction priority to a projection.
Eon Mode only
Assigns the highest depot eviction priority to a projection. Among other depot-cached objects, objects with an anti-pinning policy are the most susceptible to eviction from the depot. After eviction, the object must be read directly from communal storage the next time it is needed.
If the projection has another eviction policy already set on it, the new policy supersedes it.This is a meta-function. You must call meta-functions in a top-level SELECT statement.
Behavior type
VolatileSyntax
SET_DEPOT_ANTI_PIN_POLICY_PROJECTION ( '[[database.]schema.]projection' [, 'subcluster' ] )
Arguments
[database.]schemaDatabase and schema. The default schema is
public. If you specify a database, it must be the current database.projection- Target of this policy.
subclusterName of a depot subcluster,
default_subclusterto specify the default database subcluster. If this argument is omitted, all database depots are targeted.
Privileges
Superuser