What access path does this represent?

Posted by: Pdfprep Category: C2090-320 Tags: , ,

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/

Leave a Reply

Your email address will not be published.