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?

The correct answer is D. Table space scan access. https://flylib.com/books/en/2.608.1.155/1/

Reports and Monitoring

Question

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?

(61 responses)

#access path#ACCESSTYPE R#sequential prefetch#PLAN_TABLE

No community discussion yet for this question.