Question: what is semi join in dbms?
Answer: Semi-join strategies are technique for query processing in distributed database systems. Used for reducing communication cost. A semi-join between two tables returns rows from the first table where one or more matches are found in the second table. ... Semi-joins are written using EXISTS or IN. 8.