Compare simple join strategy and semijoin strategy.
Answers
Answered by
9
Semi-join operations are similar to regular relational joins. There is a difference though: with semi-joins, you don't care how many matches an inner table has for an outer row. In the above countries-with-big-cities example, Germany will be returned once, even if it has three cities with populations of more than one million each.
thanks :)
thanks :)
Similar questions