Performance Tuning - Question 111

Which type of table is the best candidate to be cached?

A. Small table rarely retrieved with a full table scan.

B. Large table rarely retrieved with a full table scan.

C. Small table frequently retrieved with a full table scan.

D. Large table frequently retrieved with a full table scan.

Answer: C

Explanation:

Small tables frequently retrieved with a full table scan can be cached.

Incorrect Answers

A: If table is rarely retrieved there is no sense to cache it.

B: Large table cannot be easy cached because CACHE option works mostly for the small tables that can be loaded in the memory. Also if table is rarely retrieved there is no sense to cache it.

D: Large table is not good candidate to be cached.

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 276-279

Chapter 5: Tuning the Database Buffer Cache