A JOIN execution method that, for each row in one table, scans through the other table looking for matching rows.
It's a simple mechanism that performs well when one table is small or well-indexed, but becomes inefficient when both tables are large, since the number of comparisons grows multiplicatively. It's a term that comes up often when reading a query execution plan (EXPLAIN) to see which JOIN method was used.
© 2026 ITBGM