Database Software

Conditional = supplemental columns before image is logged if supplemental columns changed

Unconditional = before image of supplemental columns always logged.

"Primary key columns must be unconditionally logged, but unique index and foreign key columns can be conditionally logged. In some cases, supplemental logging is required for additional columns in a table. For example, any columns specified in rule-based transformations or used within DML handlers must be unconditionally logged at the source database."

I'm interrupting this to mean that if I was doing a simple replication, unconditional of the PK is all I need. If I'm doing selective replication when x changes then I need to do additional unconditional logging of x?

There also seems to be complex rules around conditional logging based on parallelism at the apply side and FK's, UK's, bitmaps, etc.

Am I correct in how I'm reading this?