PMS Information Systems
Welcome to PMS Information Systems - IBM i (AS/400) Forum !!!

Get Answers for all your queries on IBM i (AS/400).

What is 'Access Path Selection’?

Go down

What is 'Access Path Selection’?

Post  maran on Sat Oct 09, 2010 5:54 pm

Access Path Selection is the process that specifies which records from a file are included in the
Access Path. Selection is made up of a number of select / omit criteria, each of which are based
on one or more conditions.

Static Selection: is built into access path.

Dynamic Selection: is not built into the implementing OS/400 access path, but it is applied at run
time. Dynamic selection is less efficient than static selection, but may help to reduce the number of
OS/400 access paths that are required.

Posts : 442
Join date : 2009-07-24

View user profile

Back to top Go down

Back to top

- Similar topics

Permissions in this forum:
You cannot reply to topics in this forum