Only UPDATEs would be affected, and only if the table hadn't been using full row logging anyway, since e.g. containing varchars.
The difference will be: instead of a single log record per UPDATE, logging only the differing bytes, two full images, before and after image of the row, would be logged - so the wider your table, the bigger typically the difference.
No difference at all for INSERTs and DELETEs.
------------------------------
Andreas Legner
------------------------------
Original Message:
Sent: Sun August 13, 2023 07:54 AM
From: Art Kagel
Subject: Activating CDC and use of logical logs
Setting full row logging will increase logical log usage for updates and deletes primarily. Inserts will only be affected if you tend to insert partial rows.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com
Original Message:
Sent: Fri August 11, 2023 05:35 PM
From: Roger Vilca
Subject: Activating CDC and use of logical logs
Hello everybody,
¿Do you now if activating a table for CDC using the function cdc_set_fullrowlogging, use much more logical log ? I have not found any reference in the documentation about it.
Please provide any clues according your experience.
Regards,
Roger
------------------------------
Roger Vilca
------------------------------