I am yet to read the Differential Dataflow paper but still interesting to read this explanation of how and why decorrelation works in database engines. LATERAL JOINs and query plans have become something of an interest of mine over the past weeks.
https://www.scattered-thoughts.net/writing/materialize-decorrelation
