Skip to main content

join_buffer

Short Description

The BUFFER or USING JOIN BUFFER join type indicates that the results of the query are being buffered for use further up the plan

Detailed Description​

The BUFFER or using_join_buffer operation indicates that an input for this step have been buffered from a previous step. Using a join buffer reduces I/O operations. Join Buffers are seen in Block Nested Loop, Batched Key Access, and hash join operations.

JSON property: using_join_buffer

Search online​

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.