Question

For sequential scans of tables we use ____________

(a) read_buffer_size

(b) join_buffer_size

(c) read_rnd_buffer_size

(d) sort_buffer_size

This question was addressed to me during an interview for a job.

Enquiry is from Web Performance Optimization in portion HTML Images & Web Page Files of HTML

Answer 1

Correct option is (a) read_buffer_size

For explanation I would say: 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.