What is semi-join in database?
Simple example. Let’s select students with grades using left outer join: Now the same with left semi-join: The latter is much more efficient.
Simple example. Let’s select students with grades using left outer join: Now the same with left semi-join: The latter is much more efficient.