-
For sequential scans of tables we use ____________.
-
- sort_buffer_size
- read_rnd_buffer_size
- join_buffer_size
- read_buffer_size
- None of these
Correct Option: D
For performing sequential scans of tables we used read_buffer_size, when reading sorted rows we use read_rnd_buffer_size, join_buffer_size are allocated per-session thus for multiple join buffers may be created. For performing sort operation we use sort_buffer_size.