I am using streams to capture changes from a ON COMMIT FAST REFRESH MATERIALIZED VIEW (with several source tables).
Both Capture and APLY process are working fine. No problems with it.
If we perform a simple update in one of the source tables, in the end, we are receiving two LCRs: one with delete command and another with insert command.
My first question why there is two LCR operations (delete and insert) instead of one (update). Is it due to the MV implementation?
Is there any mechanism or configuration where we are able to receive an update command instead of "delete and insert"? What are the trade offs?