semi-join Definition

A semi-join is a database query optimization technique used to reduce the amount of data to be processed. It involves selecting a subset of the rows from one relation and then checking if the rows in another relation match any of the selected rows. This technique can significantly improve the performance of join operations.