SET_DEPOT_PIN_POLICY_TABLE

Eon Mode only

Pins a table to a subcluster depot, or all database depots, to reduce its exposure to depot eviction. As a best practice, consider only pinning objects that are most active in DML operations and queries.

If too much depot space is claimed by pinned objects, the depot might be unable to handle load operations on unpinned objects. In this case, set configuration parameter UseDepotForWrites to 0, so load operations are routed directly to communal storage for processing. Otherwise, load operations are liable to return with an error.

Syntax

SET_DEPOT_PIN_POLICY_TABLE ( '[[database.]schema.]table' [, 'subcluster' ] )

Parameters

[database.]schema

Specifies a schema, by default public. If schema is any schema other than public, you must supply the schema name. For example:

myschema.thisDbObject

If you specify a database, it must be the current database.
table

Table to pin.

You can pin this table on a subcluster only if partitions of the table are not already pinned on the same subcluster.
subcluster Sets this pinning policy only on the depot in subcluster. If you omit this parameter, the policy is set on all depots in the database.

Privileges

Superuser

See Also