Which statement about block indexes is correct?

Question

Options

• ABecause of their large size, block indexes are extremely efficient.
• BBlock indexes improve performance when data is not clustered on sequential pages.
• CPrefetching of data pages relies on sequential detection when block indexes are used.
• DThe records for each block are retrieved using a mini-relational scan of saved data pages.

• A
  11% (3)
• B
  4% (1)
• C
  78% (21)
• D
  7% (2)

No community discussion yet for this question.