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
Additional Links​
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.