PROJECTION_DELETE_CONCERNS

Lists projections whose design may cause performance issues when deleting data. This table is generated by calling the EVALUATE_DELETE_PERFORMANCE function. See DELETE and UPDATE Optimization in the Administrator's Guide 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.