{"id":48440,"date":"2026-11-16T08:21:00","date_gmt":"2026-11-16T07:21:00","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=48440"},"modified":"2026-11-12T18:24:06","modified_gmt":"2026-11-12T17:24:06","slug":"redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/","title":{"rendered":"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study"},"content":{"rendered":"\n<p class=\"wp-block-paragraph\">I have written twice about what happens when a table replicated with GoldenGate has no primary key. I covered the common <a href=\"https:\/\/www.dbi-services.com\/blog\/goldengate-row-identification-misconceptions-and-solutions\/\" target=\"_blank\" rel=\"noopener noreferrer\">misconceptions about row identification<\/a> and the <a href=\"https:\/\/www.dbi-services.com\/blog\/lob-replication-with-goldengate-and-importance-of-primary-keys\/\" target=\"_blank\" rel=\"noopener noreferrer\">risk of migrating tables with no primary key<\/a>. Both explain why a missing key can be a real risk, but I often get asked what a missing primary key costs. Let\u2019s address these concerns, with different key strategies, multiple metrics for analysis and different variables in the experiment to balance the analysis.<\/p>\n\n\n\n<h2 id=\"four-key-strategies\" class=\"wp-block-heading\">Four key strategies<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Every scenario replicates the same table under one of four key strategies:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong><code class=\"nowrap\">PK<\/code><\/strong>: the table has a primary key.<\/li>\n\n\n\n<li><strong><code class=\"nowrap\">UNIQUE_INDEX<\/code><\/strong>: no primary key, but a unique index. GoldenGate selects it automatically as the key.<\/li>\n\n\n\n<li><strong><code class=\"nowrap\">KEYCOLS<\/code><\/strong>: no primary key and no unique index, but the <code class=\"nowrap\">KEYCOLS<\/code> parameter is added to name the columns to use as the key.<\/li>\n\n\n\n<li><strong>No key<\/strong>: scenario where no key can be identified. These are the <code class=\"nowrap\">bad_column<\/code> cases of <code class=\"nowrap\">DBA_GOLDENGATE_NOT_UNIQUE<\/code>, described in <a href=\"https:\/\/www.dbi-services.com\/blog\/goldengate-row-identification-misconceptions-and-solutions\/\" target=\"_blank\" rel=\"noopener noreferrer\">GoldenGate row identification<\/a> and <a href=\"https:\/\/www.dbi-services.com\/blog\/lob-replication-with-goldengate-and-importance-of-primary-keys\/\" target=\"_blank\" rel=\"noopener noreferrer\">LOB replication and primary keys<\/a>. The extract uses every column as a pseudo-key.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"variables-changed\" class=\"wp-block-heading\">Variables changed<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">The baseline is a table replication with 50 columns, 100,000 rows before replication, and 10,000 transactions with a 33:33:34 insert:update:delete mix. Each comparison changes one variable and keeps the others at baseline. I decided to test four variables:<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li><strong>Table width<\/strong>: 5, 50 (baseline) and 250 columns, to check which metrics are impacted by the number of columns.<\/li>\n\n\n\n<li><strong>DML mix<\/strong>: insert-only (100:0:0), update-only (0:100:0), delete-only (0:0:100) and the 33:33:34 baseline, to check which operation type pays the cost of a missing key.<\/li>\n\n\n\n<li><strong>Transaction volume<\/strong>: 10,000 (baseline) and 100,000 transactions, to check whether the cost scales linearly with the amount of work.<\/li>\n\n\n\n<li><strong>Table size<\/strong>: 100,000 (baseline) and 1,000,000 rows, to check whether the number of existing rows impacts the replication cost.<\/li>\n<\/ul>\n\n\n\n<h2 id=\"metrics-observed\" class=\"wp-block-heading\">Metrics observed<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Each test run recorded four metrics:<\/p>\n\n\n\n<ul class=\"nv-cv-m wp-block-list\">\n<li><strong>Redo generated<\/strong>: bytes of redo written by the workload session (<code>redo size<\/code> in <code class=\"nowrap\">V$MYSTAT<\/code>). DBAs worry about the redo that replication adds to the source.<\/li>\n\n\n\n<li><strong>Redo entries<\/strong>: number of redo entries written by the same session (<code>redo entries<\/code>). It shows whether the redo is made of more entries or of larger ones.<\/li>\n\n\n\n<li><strong>Trail bytes<\/strong>: bytes the extract writes to the trail.<\/li>\n\n\n\n<li><strong>Apply lag<\/strong>: time the replicat needs to apply the whole workload, from its start to the end of the apply.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Of course, other metrics could be gathered and analyzed. I wanted to focus this analysis on the ones I usually get asked about. All tests were run sequentially, to avoid concurrency issues, and randomized, to make sure that no scenario benefits from a warm cache or from a quieter moment on the server. Each scenario and key strategy was run 10 times, for around 40 hours of compute time in total.<\/p>\n\n\n\n<h2 id=\"methodology\" class=\"wp-block-heading\">Methodology<\/h2>\n\n\n\n<ul class=\"nv-cv-m wp-block-list\">\n<li><strong>Database<\/strong>: Oracle 19c, two CDBs on one host. The source PDB is in <code class=\"nowrap\">CDB01<\/code>, the target PDB in <code class=\"nowrap\">CDB02<\/code>.<\/li>\n\n\n\n<li><strong>GoldenGate<\/strong>: 26ai Microservices. Each run creates a dedicated extract, trail and replicat, then deletes them.<\/li>\n\n\n\n<li><strong>Workload<\/strong>: <code class=\"nowrap\">INSERT<\/code> adds a row, <code class=\"nowrap\">UPDATE<\/code> changes one non-key column, <code class=\"nowrap\">DELETE<\/code> removes a row. Every operation is committed individually.<\/li>\n\n\n\n<li><strong>Supplemental logging<\/strong>: added with <code>ADD TRANDATA<\/code> on every table, through the REST API. <code class=\"nowrap\">PK<\/code> and <code class=\"nowrap\">UNIQUE_INDEX<\/code> log their key columns.<\/li>\n\n\n\n<li><strong>Tables without a key<\/strong>: every column is logged, because primary key supplemental logging falls back to all columns.<\/li>\n\n\n\n<li><strong><code class=\"nowrap\">KEYCOLS<\/code><\/strong>: <code>ADD TRANDATA<\/code> also adds a log group on <code class=\"nowrap\">ID_COL<\/code>, but the fallback still applies. <code class=\"nowrap\">KEYCOLS<\/code> and no key generate the same redo. <code class=\"nowrap\">KEYCOLS<\/code> only changes the trail content and how the replicat finds the row.<\/li>\n\n\n\n<li><strong>Repeats<\/strong>: each scenario and key strategy runs 10 times. One pass covers all of them before the next repeat.<\/li>\n\n\n\n<li><strong>Capture and apply<\/strong>: the replicat starts only once the extract has finished capturing, so capture and apply never overlap and the apply lag measures the apply phase alone.<\/li>\n\n\n\n<li><strong>Statistics<\/strong>: the graphs display the mean, the standard deviation and the minimum and maximum of the 10 runs of each scenario and key strategy.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">Each chart has one row per key strategy. The box is the mean plus or minus one standard deviation, the whisker runs from the minimum to the maximum and the line is the mean.<\/p>\n\n\n\n<h2 id=\"baseline-does-key-strategy-matter\" class=\"wp-block-heading\">Baseline: does key strategy matter?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Here are the metrics for the baseline: a table with 50 columns, 100,000 rows and 10,000 transactions with an equal DML mix.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"328\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1-1024x328.png\" alt=\"\" class=\"wp-image-48445\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1-1024x328.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1-300x96.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1-768x246.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1-1536x492.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"328\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/002_pk-impact-baseline-redo-entries-1024x328.png\" alt=\"\" class=\"wp-image-48442\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/002_pk-impact-baseline-redo-entries-1024x328.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/002_pk-impact-baseline-redo-entries-300x96.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/002_pk-impact-baseline-redo-entries-768x246.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/002_pk-impact-baseline-redo-entries-1536x492.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/002_pk-impact-baseline-redo-entries.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"328\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/003_pk-impact-baseline-trail-bytes-1024x328.png\" alt=\"\" class=\"wp-image-48443\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/003_pk-impact-baseline-trail-bytes-1024x328.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/003_pk-impact-baseline-trail-bytes-768x246.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/003_pk-impact-baseline-trail-bytes-300x96.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/003_pk-impact-baseline-trail-bytes-1536x492.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/003_pk-impact-baseline-trail-bytes.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"328\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/004_pk-impact-baseline-apply-lag-seconds-1024x328.png\" alt=\"\" class=\"wp-image-48444\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/004_pk-impact-baseline-apply-lag-seconds-1024x328.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/004_pk-impact-baseline-apply-lag-seconds-300x96.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/004_pk-impact-baseline-apply-lag-seconds-768x246.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/004_pk-impact-baseline-apply-lag-seconds-1536x492.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/004_pk-impact-baseline-apply-lag-seconds.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Key strategy<\/th><th>Redo<\/th><th>Redo entries<\/th><th>Trail<\/th><th>Apply lag<\/th><\/tr><\/thead><tbody><tr><td><code class=\"nowrap\">PK<\/code><\/td><td>15.0 MB<\/td><td>33.2k<\/td><td>11.1 MB<\/td><td>11.1 s<\/td><\/tr><tr><td><code class=\"nowrap\">UNIQUE_INDEX<\/code><\/td><td>15.0 MB<\/td><td>33.2k<\/td><td>11.1 MB<\/td><td>11.2 s<\/td><\/tr><tr><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>15.5 MB<\/td><td>23.1k<\/td><td>15.2 MB<\/td><td>21.3 s<\/td><\/tr><tr><td>No key<\/td><td>15.5 MB<\/td><td>23.1k<\/td><td>19.4 MB<\/td><td>21.2 s<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li><strong><code class=\"nowrap\">PK<\/code> and <code class=\"nowrap\">UNIQUE_INDEX<\/code> give the same results<\/strong> on every metric, and so do <strong><code class=\"nowrap\">KEYCOLS<\/code> and no key<\/strong>, except for the trail volume.<\/li>\n\n\n\n<li><strong>Trail volume<\/strong> is the only metric where <code class=\"nowrap\">KEYCOLS<\/code> and no key differ: <code class=\"nowrap\">KEYCOLS<\/code> reduces it by 21%, but it stays 37% above the scenario where a <code class=\"nowrap\">PK<\/code> is used.<\/li>\n\n\n\n<li><strong><code class=\"nowrap\">KEYCOLS<\/code> has no impact on the redo generated<\/strong>, which is the same as no key (see <a href=\"#methodology\">supplemental logging<\/a>).<\/li>\n\n\n\n<li>With a <code class=\"nowrap\">PK<\/code> or <code class=\"nowrap\">UNIQUE_INDEX<\/code>, apply lag is 47% lower and redo is 3% lower than with <code class=\"nowrap\">KEYCOLS<\/code> or no key.<\/li>\n\n\n\n<li>A <code class=\"nowrap\">PK<\/code> or <code class=\"nowrap\">UNIQUE_INDEX<\/code> adds 43% more redo entries than <code class=\"nowrap\">KEYCOLS<\/code> or no key, because of the index maintenance.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">With <code class=\"nowrap\">KEYCOLS<\/code> or no key, the replicat takes about twice as long to apply the same workload. The trail is 37% larger with <code class=\"nowrap\">KEYCOLS<\/code> and 75% larger with no key. The redo on the source barely changes.<\/p>\n\n\n\n<h2 id=\"does-a-wider-table-cost-more\" class=\"wp-block-heading\">Does a wider table cost more?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Here is each metric for three different tables: 5, 50 (baseline) and 250 columns.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/005_pk-impact-column-count-redo-size-1024x669.png\" alt=\"\" class=\"wp-image-48446\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/005_pk-impact-column-count-redo-size-1024x669.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/005_pk-impact-column-count-redo-size-300x196.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/005_pk-impact-column-count-redo-size-767x501.png 767w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/005_pk-impact-column-count-redo-size-1536x1003.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/005_pk-impact-column-count-redo-size.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/006_pk-impact-column-count-redo-entries-1024x669.png\" alt=\"\" class=\"wp-image-48447\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/006_pk-impact-column-count-redo-entries-1024x669.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/006_pk-impact-column-count-redo-entries-300x196.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/006_pk-impact-column-count-redo-entries-767x501.png 767w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/006_pk-impact-column-count-redo-entries-1536x1003.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/006_pk-impact-column-count-redo-entries.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/007_pk-impact-column-count-trail-bytes-1024x669.png\" alt=\"\" class=\"wp-image-48448\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/007_pk-impact-column-count-trail-bytes-1024x669.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/007_pk-impact-column-count-trail-bytes-300x196.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/007_pk-impact-column-count-trail-bytes-767x501.png 767w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/007_pk-impact-column-count-trail-bytes-1536x1003.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/007_pk-impact-column-count-trail-bytes.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"669\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/008_pk-impact-column-count-apply-lag-seconds-1024x669.png\" alt=\"\" class=\"wp-image-48449\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/008_pk-impact-column-count-apply-lag-seconds-1024x669.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/008_pk-impact-column-count-apply-lag-seconds-767x501.png 767w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/008_pk-impact-column-count-apply-lag-seconds-1536x1003.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/008_pk-impact-column-count-apply-lag-seconds-300x196.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/008_pk-impact-column-count-apply-lag-seconds.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Columns<\/th><th>Key strategy<\/th><th>Redo<\/th><th>Redo entries<\/th><th>Trail<\/th><th>Apply lag<\/th><\/tr><\/thead><tbody><tr><td>5<\/td><td><code class=\"nowrap\">PK<\/code><\/td><td>10.6 MB<\/td><td>30.3k<\/td><td>3.3 MB<\/td><td>11.1 s<\/td><\/tr><tr><td>5<\/td><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>8.5 MB<\/td><td>20.2k<\/td><td>3.6 MB<\/td><td>11.2 s<\/td><\/tr><tr><td>5<\/td><td>No key<\/td><td>8.5 MB<\/td><td>20.2k<\/td><td>4.0 MB<\/td><td>11.1 s<\/td><\/tr><tr><td>50<\/td><td><code class=\"nowrap\">PK<\/code><\/td><td>15.0 MB<\/td><td>33.2k<\/td><td>11.1 MB<\/td><td>11.1 s<\/td><\/tr><tr><td>50<\/td><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>15.5 MB<\/td><td>23.1k<\/td><td>15.2 MB<\/td><td>21.3 s<\/td><\/tr><tr><td>50<\/td><td>No key<\/td><td>15.5 MB<\/td><td>23.1k<\/td><td>19.4 MB<\/td><td>21.2 s<\/td><\/tr><tr><td>250<\/td><td><code class=\"nowrap\">PK<\/code><\/td><td>34.7 MB<\/td><td>46.1k<\/td><td>45.7 MB<\/td><td>12.4 s<\/td><\/tr><tr><td>250<\/td><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>46.5 MB<\/td><td>36.7k<\/td><td>67.2 MB<\/td><td>83.2 s<\/td><\/tr><tr><td>250<\/td><td>No key<\/td><td>46.5 MB<\/td><td>36.7k<\/td><td>88.3 MB<\/td><td>85.2 s<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p class=\"wp-block-paragraph\">A missing key costs more as the table gets wider. At 5 columns it costs nothing on apply lag. At 250 columns the apply lag is about 7 times higher, the trail almost twice as large and the redo 34% higher.<\/p>\n\n\n\n<h3 id=\"why-the-redo-gap-changes-with-the-table-width\" class=\"wp-block-heading\">Why the redo gap changes with the table width<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">When the table width increases, two costs go in opposite directions.<\/p>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li><strong>Index maintenance<\/strong>: <code class=\"nowrap\">INSERT<\/code> and <code class=\"nowrap\">DELETE<\/code> on a keyed table add or remove a B-tree entry. The cost is fixed per operation. <code class=\"nowrap\">UPDATE<\/code> never changes the index here.<\/li>\n\n\n\n<li><strong>Full-row logging<\/strong>: a no-key table logs every column on each <code class=\"nowrap\">UPDATE<\/code>. The cost grows with the column count.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">At 5 columns the fixed index cost dominates and no key generates 20% less redo than <code class=\"nowrap\">PK<\/code>. At 50 columns no key is 3% above, and at 250 columns it is 34% above.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">The entry counts match. <code class=\"nowrap\">PK<\/code> writes more entries than no key at every width, because of the index: 50% more at 5 columns, 43% at 50 and 26% at 250.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Apply lag at 250 columns is noisy for <code class=\"nowrap\">KEYCOLS<\/code> and no key (coefficient of variation 38% to 47%). Their medians are about 6 times that of <code class=\"nowrap\">PK<\/code>.<\/p>\n\n\n\n<h2 id=\"which-workload-type-pays-for-a-missing-key\" class=\"wp-block-heading\">Which workload type pays for a missing key?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\"><code class=\"nowrap\">INSERT<\/code> has no row to identify, so only the index maintenance cost applies. <code class=\"nowrap\">UPDATE<\/code> and <code class=\"nowrap\">DELETE<\/code> identify a row.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"827\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/009_pk-impact-dml-mix-redo-size-1024x827.png\" alt=\"\" class=\"wp-image-48450\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/009_pk-impact-dml-mix-redo-size-1024x827.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/009_pk-impact-dml-mix-redo-size-300x242.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/009_pk-impact-dml-mix-redo-size-767x619.png 767w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/009_pk-impact-dml-mix-redo-size-1536x1240.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/009_pk-impact-dml-mix-redo-size.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"827\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/010_pk-impact-dml-mix-redo-entries-1024x827.png\" alt=\"\" class=\"wp-image-48451\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/010_pk-impact-dml-mix-redo-entries-1024x827.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/010_pk-impact-dml-mix-redo-entries-300x242.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/010_pk-impact-dml-mix-redo-entries-767x619.png 767w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/010_pk-impact-dml-mix-redo-entries-1536x1240.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/010_pk-impact-dml-mix-redo-entries.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"827\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/011_pk-impact-dml-mix-trail-bytes-1024x827.png\" alt=\"\" class=\"wp-image-48452\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/011_pk-impact-dml-mix-trail-bytes-1024x827.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/011_pk-impact-dml-mix-trail-bytes-300x242.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/011_pk-impact-dml-mix-trail-bytes-767x619.png 767w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/011_pk-impact-dml-mix-trail-bytes-1536x1240.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/011_pk-impact-dml-mix-trail-bytes.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"827\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/012_pk-impact-dml-mix-apply-lag-seconds-1024x827.png\" alt=\"\" class=\"wp-image-48453\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/012_pk-impact-dml-mix-apply-lag-seconds-1024x827.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/012_pk-impact-dml-mix-apply-lag-seconds-300x242.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/012_pk-impact-dml-mix-apply-lag-seconds-767x619.png 767w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/012_pk-impact-dml-mix-apply-lag-seconds-1536x1240.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/012_pk-impact-dml-mix-apply-lag-seconds.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Workload<\/th><th>Key strategy<\/th><th>Redo<\/th><th>Redo entries<\/th><th>Trail<\/th><th>Apply lag<\/th><\/tr><\/thead><tbody><tr><td>Insert-only<\/td><td><code class=\"nowrap\">PK<\/code><\/td><td>18.7 MB<\/td><td>35.1k<\/td><td>15.2 MB<\/td><td>11.1 s<\/td><\/tr><tr><td>Insert-only<\/td><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>15.2 MB<\/td><td>24.9k<\/td><td>15.2 MB<\/td><td>11.2 s<\/td><\/tr><tr><td>Insert-only<\/td><td>No key<\/td><td>15.2 MB<\/td><td>24.9k<\/td><td>15.2 MB<\/td><td>11.1 s<\/td><\/tr><tr><td>Update-only<\/td><td><code class=\"nowrap\">PK<\/code><\/td><td>8.0 MB<\/td><td>20.0k<\/td><td>2.8 MB<\/td><td>11.1 s<\/td><\/tr><tr><td>Update-only<\/td><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>16.4 MB<\/td><td>20.2k<\/td><td>15.4 MB<\/td><td>30.4 s<\/td><\/tr><tr><td>Update-only<\/td><td>No key<\/td><td>16.4 MB<\/td><td>20.2k<\/td><td>27.9 MB<\/td><td>31.4 s<\/td><\/tr><tr><td>Delete-only<\/td><td><code class=\"nowrap\">PK<\/code><\/td><td>17.9 MB<\/td><td>42.8k<\/td><td>15.1 MB<\/td><td>11.1 s<\/td><\/tr><tr><td>Delete-only<\/td><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>14.5 MB<\/td><td>22.8k<\/td><td>15.1 MB<\/td><td>31.4 s<\/td><\/tr><tr><td>Delete-only<\/td><td>No key<\/td><td>14.5 MB<\/td><td>22.8k<\/td><td>15.1 MB<\/td><td>31.6 s<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li><strong>Insert-only<\/strong>: a key costs 23% more redo, from the index entries. Trail bytes and apply lag are identical.<\/li>\n\n\n\n<li><strong>Delete-only<\/strong>: a key costs 24% more redo, for the same reason. Apply lag is almost 3 times higher without a key.<\/li>\n\n\n\n<li><strong>Update-only<\/strong>: no key generates twice the redo of a key. Trail bytes are 5.5 times larger with <code class=\"nowrap\">KEYCOLS<\/code> and 10 times larger with no key than with <code class=\"nowrap\">PK<\/code>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\"><code class=\"nowrap\">INSERT<\/code> pays nothing: apply lag and trail are the same with or without a key. <code class=\"nowrap\">DELETE<\/code> makes the apply almost 3 times slower, and <code class=\"nowrap\">UPDATE<\/code> is the worst case, with a trail 5.5 to 10 times larger and twice the redo. The cost of a missing key falls entirely on the statements that have to find an existing row.<\/p>\n\n\n\n<h2 id=\"does-the-cost-scale-with-the-workload\" class=\"wp-block-heading\">Does the cost scale with the workload?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Each transaction is independent. Every metric should scale by 10x from 10,000 to 100,000 transactions.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/013_pk-impact-transaction-count-redo-size-1024x511.png\" alt=\"\" class=\"wp-image-48454\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/013_pk-impact-transaction-count-redo-size-1024x511.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/013_pk-impact-transaction-count-redo-size-300x150.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/013_pk-impact-transaction-count-redo-size-768x383.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/013_pk-impact-transaction-count-redo-size-1536x766.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/013_pk-impact-transaction-count-redo-size.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/014_pk-impact-transaction-count-redo-entries-1024x511.png\" alt=\"\" class=\"wp-image-48458\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/014_pk-impact-transaction-count-redo-entries-1024x511.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/014_pk-impact-transaction-count-redo-entries-768x383.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/014_pk-impact-transaction-count-redo-entries-300x150.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/014_pk-impact-transaction-count-redo-entries-1536x766.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/014_pk-impact-transaction-count-redo-entries.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/015_pk-impact-transaction-count-trail-bytes-1024x511.png\" alt=\"\" class=\"wp-image-48456\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/015_pk-impact-transaction-count-trail-bytes-1024x511.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/015_pk-impact-transaction-count-trail-bytes-300x150.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/015_pk-impact-transaction-count-trail-bytes-768x383.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/015_pk-impact-transaction-count-trail-bytes-1536x766.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/015_pk-impact-transaction-count-trail-bytes.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/016_pk-impact-transaction-count-apply-lag-seconds-1024x511.png\" alt=\"\" class=\"wp-image-48457\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/016_pk-impact-transaction-count-apply-lag-seconds-1024x511.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/016_pk-impact-transaction-count-apply-lag-seconds-300x150.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/016_pk-impact-transaction-count-apply-lag-seconds-768x383.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/016_pk-impact-transaction-count-apply-lag-seconds-1536x766.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/016_pk-impact-transaction-count-apply-lag-seconds.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Key strategy<\/th><th>Redo<\/th><th>Trail<\/th><th>Apply lag<\/th><\/tr><\/thead><tbody><tr><td><code class=\"nowrap\">PK<\/code><\/td><td>10.23x<\/td><td>9.99x<\/td><td>1.9x<\/td><\/tr><tr><td><code class=\"nowrap\">UNIQUE_INDEX<\/code><\/td><td>10.23x<\/td><td>9.99x<\/td><td>1.9x<\/td><\/tr><tr><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>10.20x<\/td><td>10.00x<\/td><td>6.8x<\/td><\/tr><tr><td>No key<\/td><td>10.20x<\/td><td>10.00x<\/td><td>7.5x<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li><strong>Redo and trail bytes<\/strong> scale linearly for every key strategy.<\/li>\n\n\n\n<li><strong>Apply lag<\/strong> grows 7x for <code class=\"nowrap\">KEYCOLS<\/code>, 7.5x for no key and 2x for <code class=\"nowrap\">PK<\/code>.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">The gap grows faster than the volume: with 10 times more transactions, apply lag only doubles with a key but is multiplied by 7 without one, so a missing key goes from about 2 times slower to about 7 times slower.<\/p>\n\n\n\n<h2 id=\"does-the-number-of-rows-change-the-cost\" class=\"wp-block-heading\">Does the number of rows change the cost?<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">Each run changes a fixed number of rows. The table size should not change redo, trail bytes or apply lag.<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1024x511.png\" alt=\"\" class=\"wp-image-48459\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1024x511.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-300x150.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-768x383.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1536x766.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1-1024x511.png\" alt=\"\" class=\"wp-image-48460\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1-1024x511.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1-768x383.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1-300x150.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1-1536x766.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/018_pk-impact-row-count-redo-entries-1.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/019_pk-impact-row-count-trail-bytes-1024x511.png\" alt=\"\" class=\"wp-image-48461\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/019_pk-impact-row-count-trail-bytes-1024x511.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/019_pk-impact-row-count-trail-bytes-300x150.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/019_pk-impact-row-count-trail-bytes-768x383.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/019_pk-impact-row-count-trail-bytes-1536x766.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/019_pk-impact-row-count-trail-bytes.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"511\" src=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/020_pk-impact-row-count-apply-lag-seconds-1024x511.png\" alt=\"\" class=\"wp-image-48462\" srcset=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/020_pk-impact-row-count-apply-lag-seconds-1024x511.png 1024w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/020_pk-impact-row-count-apply-lag-seconds-300x150.png 300w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/020_pk-impact-row-count-apply-lag-seconds-768x383.png 768w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/020_pk-impact-row-count-apply-lag-seconds-1536x766.png 1536w, https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/020_pk-impact-row-count-apply-lag-seconds.png 1660w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\n<\/div>\n\n\n<figure class=\"wp-block-table\"><table><thead><tr><th>Key strategy<\/th><th>Redo, 100k to 1M rows<\/th><th>Trail, 100k to 1M rows<\/th><th>Apply lag, 100k to 1M rows<\/th><\/tr><\/thead><tbody><tr><td><code class=\"nowrap\">PK<\/code><\/td><td>15.0 to 14.9 MB<\/td><td>11.1 to 11.2 MB<\/td><td>11.1 to 11.1 s<\/td><\/tr><tr><td><code class=\"nowrap\">UNIQUE_INDEX<\/code><\/td><td>15.0 to 14.9 MB<\/td><td>11.1 to 11.2 MB<\/td><td>11.2 to 11.1 s<\/td><\/tr><tr><td><code class=\"nowrap\">KEYCOLS<\/code><\/td><td>15.5 to 15.5 MB<\/td><td>15.2 to 15.4 MB<\/td><td>21.3 to 200.5 s<\/td><\/tr><tr><td>No key<\/td><td>15.5 to 15.5 MB<\/td><td>19.4 to 19.6 MB<\/td><td>21.2 to 229.5 s<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li><strong><code class=\"nowrap\">PK<\/code> and <code class=\"nowrap\">UNIQUE_INDEX<\/code><\/strong> are unchanged, as expected.<\/li>\n\n\n\n<li><strong>Redo<\/strong> does not change with table size for any key strategy.<\/li>\n\n\n\n<li><strong>Apply lag<\/strong> is 9 times higher for <code class=\"nowrap\">KEYCOLS<\/code> and 11 times higher for no key. The likely cause is that their target tables have no index on the key columns and are 10 times larger.<\/li>\n<\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">With a key, table size does not matter. Without one, a table 10 times larger makes the apply 9 times slower with <code class=\"nowrap\">KEYCOLS<\/code> and 11 times slower with no key, because the replicat has to search the table for every row it changes.<\/p>\n\n\n\n<h2 id=\"conclusion\" class=\"wp-block-heading\">Conclusion<\/h2>\n\n\n\n<ul class=\"nv-cv-d nv-cv-m wp-block-list\">\n<li><strong>As expected, <code class=\"nowrap\">PK<\/code> and <code class=\"nowrap\">UNIQUE_INDEX<\/code> are the same for GoldenGate<\/strong>: redo, trail and apply lag are the same in every scenario tested. A unique index is as good as a primary key.<\/li>\n\n\n\n<li><strong>No key costs apply lag and trail volume<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Compared with a <code class=\"nowrap\">PK<\/code>, the apply is about twice as slow at baseline and the trail is 75% larger.<\/li>\n\n\n\n<li>The gap grows with table width, workload volume and table size: the apply is up to 20 times slower, and the trail is 10 times larger on an update-only workload.<\/li>\n\n\n\n<li>It comes entirely from <code class=\"nowrap\">UPDATE<\/code> and <code class=\"nowrap\">DELETE<\/code>: <code class=\"nowrap\">INSERT<\/code> costs nothing on apply lag.<\/li>\n\n\n\n<li>Redo stays within a few percent at baseline. It is 34% higher at 250 columns, but 20% lower on narrow tables and insert-only workloads, because there is no index to maintain.<\/li>\n<\/ul>\n<\/li>\n\n\n\n<li><strong><code class=\"nowrap\">KEYCOLS<\/code> is not a workaround for a missing key<\/strong>:\n<ul class=\"wp-block-list\">\n<li>Compared with a <code class=\"nowrap\">PK<\/code>, the apply is about twice as slow at baseline and the trail is 37% larger.<\/li>\n\n\n\n<li>Compared with no key, the only gain is a smaller trail (21% at baseline). Redo and apply lag do not improve.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>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&hellip;&nbsp;<\/p>\n","protected":false},"author":152,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","neve_meta_reading_time":"","_themeisle_gutenberg_block_has_review":false,"footnotes":""},"categories":[4133,3787,59],"tags":[22675,22673,22682,22678,67,4077,874,301,255,3813],"class_list":["post-48440","post","type-post","status-publish","format-standard","category-database","category-goldengate","category-oracle","tag-26ai","tag-goldengate","tag-keycols","tag-ogg","tag-performance","tag-primary-key","tag-redo","tag-replication","tag-statistics","tag-trail"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v28.8 (Yoast SEO v28.8) - https:\/\/yoast.com\/product\/yoast-seo-premium-wordpress\/ -->\n<title>Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study - dbi services Blog<\/title>\n<meta name=\"description\" content=\"Redo trail volume and apply lag by primary key strategy in Oracle GoldenGate: a controlled empirical study across five workload dimensions.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study\" \/>\n<meta property=\"og:description\" content=\"Redo trail volume and apply lag by primary key strategy in Oracle GoldenGate: a controlled empirical study across five workload dimensions.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi services Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/dbiservices\/\" \/>\n<meta property=\"article:published_time\" content=\"2026-11-16T07:21:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1660\" \/>\n\t<meta property=\"og:image:height\" content=\"532\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Julien Delattre\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:site\" content=\"@dbiservices\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Julien Delattre\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"13 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/\"},\"author\":{\"name\":\"Julien Delattre\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0e990b04385bd7ff84b414bb8d92c544\"},\"headline\":\"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study\",\"datePublished\":\"2026-11-16T07:21:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/\"},\"wordCount\":1693,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/001_pk-impact-baseline-redo-size-1-1024x328.png\",\"keywords\":[\"26ai\",\"goldengate\",\"keycols\",\"ogg\",\"Performance\",\"primary key\",\"redo\",\"Replication\",\"Statistics\",\"trail\"],\"articleSection\":[\"Database\",\"GoldenGate\",\"Oracle\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/\",\"name\":\"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study - dbi services Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/001_pk-impact-baseline-redo-size-1-1024x328.png\",\"datePublished\":\"2026-11-16T07:21:00+00:00\",\"description\":\"Redo trail volume and apply lag by primary key strategy in Oracle GoldenGate: a controlled empirical study across five workload dimensions.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/001_pk-impact-baseline-redo-size-1.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/11\\\/001_pk-impact-baseline-redo-size-1.png\",\"width\":1660,\"height\":532},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/\",\"name\":\"dbi services Blog\",\"description\":\"#BeSharing\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/#organization\",\"name\":\"dbi services\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2026\\\/09\\\/dbi-services-logo.png\",\"width\":512,\"height\":512,\"caption\":\"dbi services\"},\"image\":{\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/dbiservices\\\/\",\"https:\\\/\\\/x.com\\\/dbiservices\",\"https:\\\/\\\/www.linkedin.com\\\/company\\\/dbi-services\\\/\",\"https:\\\/\\\/www.youtube.com\\\/user\\\/dbiservices\"],\"description\":\"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.\",\"email\":\"info@dbi-services.com\",\"telephone\":\"+41 32 422 96 00\",\"legalName\":\"dbi services SA\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/#\\\/schema\\\/person\\\/0e990b04385bd7ff84b414bb8d92c544\",\"name\":\"Julien Delattre\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"contentUrl\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/05\\\/JDE_Web-1-scaled.jpg\",\"caption\":\"Julien Delattre\"},\"description\":\"Julien Delattre, member of the Oracle Team Zurich, has more than five years of experience specializing in Oracle databases, plus expertise in MariaDB and MongoDB. Prior to dbi services, he was a Database Administrator at Atos in Angers, France, and a Data Scientist at Air France in Paris and Apurata in Lima. Julien holds a Master's degree in Computer Science, Data Science, and Statistics from Centrale Paris \\\/ Universit\u00e9 Paris-Saclay.\",\"url\":\"https:\\\/\\\/www.dbi-services.com\\\/blog\\\/author\\\/julien-delattre\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study - dbi services Blog","description":"Redo trail volume and apply lag by primary key strategy in Oracle GoldenGate: a controlled empirical study across five workload dimensions.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/","og_locale":"en_US","og_type":"article","og_title":"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study","og_description":"Redo trail volume and apply lag by primary key strategy in Oracle GoldenGate: a controlled empirical study across five workload dimensions.","og_url":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/","og_site_name":"dbi services Blog","article_publisher":"https:\/\/www.facebook.com\/dbiservices\/","article_published_time":"2026-11-16T07:21:00+00:00","og_image":[{"width":1660,"height":532,"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1.png","type":"image\/png"}],"author":"Julien Delattre","twitter_card":"summary_large_image","twitter_creator":"@dbiservices","twitter_site":"@dbiservices","twitter_misc":{"Written by":"Julien Delattre","Est. reading time":"13 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/"},"author":{"name":"Julien Delattre","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0e990b04385bd7ff84b414bb8d92c544"},"headline":"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study","datePublished":"2026-11-16T07:21:00+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/"},"wordCount":1693,"commentCount":0,"publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1-1024x328.png","keywords":["26ai","goldengate","keycols","ogg","Performance","primary key","redo","Replication","Statistics","trail"],"articleSection":["Database","GoldenGate","Oracle"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/","url":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/","name":"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study - dbi services Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1-1024x328.png","datePublished":"2026-11-16T07:21:00+00:00","description":"Redo trail volume and apply lag by primary key strategy in Oracle GoldenGate: a controlled empirical study across five workload dimensions.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/11\/001_pk-impact-baseline-redo-size-1.png","width":1660,"height":532},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/redo-trail-volume-and-apply-lag-by-key-strategy-in-oracle-goldengate-a-controlled-empirical-study\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Redo, trail volume, and apply lag by key strategy in Oracle GoldenGate: a controlled empirical study"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi services Blog","description":"#BeSharing","publisher":{"@id":"https:\/\/www.dbi-services.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.dbi-services.com\/#organization","name":"dbi services","url":"https:\/\/www.dbi-services.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2026\/09\/dbi-services-logo.png","width":512,"height":512,"caption":"dbi services"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/dbiservices\/","https:\/\/x.com\/dbiservices","https:\/\/www.linkedin.com\/company\/dbi-services\/","https:\/\/www.youtube.com\/user\/dbiservices"],"description":"Swiss IT consulting and services company specialized in efficient data infrastructures and platforms: databases, application servers, cloud, DevOps, digitalization, analytics, data quality and monitoring. Headquartered in Del\u00e9mont with offices in Nyon, Basel, Bern and Zurich.","email":"info@dbi-services.com","telephone":"+41 32 422 96 00","legalName":"dbi services SA"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/0e990b04385bd7ff84b414bb8d92c544","name":"Julien Delattre","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/2025\/05\/JDE_Web-1-scaled.jpg","caption":"Julien Delattre"},"description":"Julien Delattre, member of the Oracle Team Zurich, has more than five years of experience specializing in Oracle databases, plus expertise in MariaDB and MongoDB. Prior to dbi services, he was a Database Administrator at Atos in Angers, France, and a Data Scientist at Air France in Paris and Apurata in Lima. Julien holds a Master's degree in Computer Science, Data Science, and Statistics from Centrale Paris \/ Universit\u00e9 Paris-Saclay.","url":"https:\/\/www.dbi-services.com\/blog\/author\/julien-delattre\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48440","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/152"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=48440"}],"version-history":[{"count":2,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48440\/revisions"}],"predecessor-version":[{"id":48466,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/48440\/revisions\/48466"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=48440"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=48440"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=48440"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}