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

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

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