Tag: joins
All the articles with the tag "joins".
Why your JOIN returns more rows than either table
A JOIN that returns 40,000 rows from two tables of 200 usually means one thing. Underneath, every JOIN is a Cartesian product with a filter on top.
All the articles with the tag "joins".
A JOIN that returns 40,000 rows from two tables of 200 usually means one thing. Underneath, every JOIN is a Cartesian product with a filter on top.