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

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

Join the forum, it's quick and easy

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

Get Answers for all your queries on IBM i (AS/400).
PMS Information Systems
Would you like to react to this message? Create an account in a few clicks or log in to continue.

What is 'Access Path Selection’?

Go down

What is 'Access Path Selection’? Empty What is 'Access Path Selection’?

Post  maran 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.
maran
maran
Admin

Posts : 442
Join date : 2009-07-24

https://pmsinformationsystem.forumotion.net

Back to top Go down

Back to top

- Similar topics

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