A join buffer is a temporary storage area used by database systems to optimize join operations, particularly when dealing with large datasets where in-memory operations are not feasible. It helps in reducing the number of disk I/O operations by holding intermediate results, thus improving the performance of SQL queries involving joins.