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. |