Oracle ID Dedup: 23% Faster by Changing the Key, 9% Faster by Removing Dead Work
·8 mins
Two SQL hypotheses about DISTINCT ON key choice: UUID vs text, and whether DISTINCT ON the primary key does any real work. One hypothesis failed; two wins shipped.