Join Small Table to Big Table or Vice Versa, does it matter?
Posted by serge on 10/01/22 11:19
If I join Table1 to Table2 with a WHERE condition, is
it the same if I would join Table2 to Table1 considering
that the size of the tables are different.
Let's assume Table2 is much bigger than Table1.
I've never used MERGE, HASH JOINs etc, do any of
these help in this scenario?