If your materialized view is linked to a composite primary key - this potentially could hit some refresh issues. Logic specific to our business needs has been added to handle this scenario for certain materialized views. This has been labelled CDL Specific in the comments if you'd like to review what has been done.
This will needs reviewing in full for a permanent solution. 95% of our materialized reviews don't use composite primary keys.
If your materialized view is linked to a composite primary key - this potentially could hit some refresh issues. Logic specific to our business needs has been added to handle this scenario for certain materialized views. This has been labelled CDL Specific in the comments if you'd like to review what has been done.
This will needs reviewing in full for a permanent solution. 95% of our materialized reviews don't use composite primary keys.