;
Subject: performance of IN clause
Is there a significant differrence in how a IN clause performs when compared
to a JOIN?
Let's say I have 2 tables, A and B/ B has 50million rows and A has 1 million
Will this query?
Select * from A where join_key in (Select join_key from B)
perform much worse th
Is there a significant differrence in how a IN clause performs when
compared to a JOIN?
Let's say I have 2 tables, A and B/ B has 50million rows and A has 1 million
Will this query?
*Select * from A where join_key in (Select join_key from B)*
*perform much worse than*
* Select * from A*
*INNER