PROJECTION_DELETE_CONCERNS

Lists projections whose design are liable to cause performance issues when deleting data.

Lists projections whose design are liable to cause performance issues when deleting data. This table is generated by calling the EVALUATE_DELETE_PERFORMANCE function. See Optimizing DELETE and UPDATE for more information.

Column Name Data Type Description
PROJECTION_ID INTEGER The ID number of the projection
PROJECTION_SCHEMA VARCHAR The schema containing the projection
PROJECTION_NAME VARCHAR The projection's name
CREATION_TIME TIMESTAMPTZ When the projection was created
LAST_MODIFIED_TIME TIMESTAMPTZ When the projection was last modified
COMMENT VARCHAR A comment describing the potential delete performance issue.