Deleting unused projections
Thank you for your interest.
Currently, there are projections that are being notified as candidates for deletion by ManagementConsole.
TBL_pk_b1 in the following table.
The following projections exist in the table.
|TBL_pk_b0||TBL1||DELAYED CREATION||f||t||hash(TBL1.COL1, TBL1.COL2)|
|TBL_pk_b1||TBL1||DELAYED CREATION||f||t||hash(TBL1.COL1, TBL1.COL2)|
Also, if you check
v_catalog.projection_usage, there is no usage history for the projection in question.
Deleting it doesn't seem to be a problem.
I'd like to know if it's OK for the
is_key_constraint_projection=true projection to no longer exist.
That's all, I'm looking forward to your answer.