Consider the join_buffer_size parameter in MySQL Server.
Which two statements are true about the join buffer? (Choose two.)
The value should be increased if the client performs several SELECT operations.
The join buffer is set per connection.
The join buffer is used to process sorts when complex joins are being performed.
The value should be increased from the default if the query joins large rows without using an index.
The join buffer is global and can be changed only by restarting the server.
Submit