Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study
I have written twice about what happens when a table replicated with GoldenGate has no primary key. I covered the common misconceptions about row identification and the risk of migrating tables with no primary key. Both explain why a missing key can be a real risk, but I often get asked what a missing primary key costs. Let’s address these…
