Home » HTML » Html miscellaneous » Question
  1. For sequential scans of tables we use ____________.
    1. sort_buffer_size
    2. read_rnd_buffer_size
    3. join_buffer_size
    4. read_buffer_size
    5. 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.



Your comments will be displayed only after manual approval.