Sunday, 13 September 2009

Performance Tuning - Question 066.

Which of these are performance advantages of using a small block size? (Choose two.)

A . A small number of rows per block.

B. Random access is relatively more efficient.

C. Reduced block contention.

D . Good for sequential access.

Explanation:

Answer B and C: A small block size means that you'll get fewer rows into a block. However, random access improves because they don't have to read as much erroneous information.

No comments:

Post a Comment