PrepAway - Latest Free Exam Questions & Answers

Which statement about block indexes is correct?

Which statement about block indexes is correct?

PrepAway - Latest Free Exam Questions & Answers

A.
Because of their large size, block indexes are extremely efficient.

B.
Block indexes improve performance when data is not clustered on sequential pages.

C.
Prefetching of data pages relies on sequential detection when block indexes are used.

D.
The records for each block are retrieved using a mini-relational scan of saved data pages.

Explanation:


Leave a Reply