Skip to main content


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.

DBmarlin Trial