PARTITION_PROJECTION
Splits ROS containers for a specified projection. PARTITION_PROJECTION
also purges data while partitioning ROS containers if deletes were applied before the AHM epoch.
Syntax
PARTITION_PROJECTION ( '[schema.]projection‑name')
Parameters
schema |
Specifies a schema. If multiple schemas are defined in the database, include the schema name. For example: myschema.thisDbObject |
projection‑name |
The projection to partition. |
Privileges
- Table owner
- USAGE privilege on schema
Examples
In this example, PARTITION_PROJECTION
forces a split of ROS containers on the states_p
projection:
=> SELECT PARTITION_PROJECTION ('states_p'); PARTITION_PROJECTION ------------------------ Projection partitioned (1 row)