An application program is running much longer than expected. The PLAN_TABLE shows the following access path information:
ACCESSTYPE = ‘R’ PREFETCH = ‘S’
What access path does this represent?
A . IN-list access
B . Direct row access
C . Dynamic prefetch access
D . Table space scan access
Answer: D
Explanation:
Reference: https://flylib.com/books/en/2.608.1.155/1/