What is 'Access Path Selection’?
Page 1 of 1
What is 'Access Path Selection’?
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.
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- Admin
- Posts : 442
Join date : 2009-07-24 -
Similar topics» What is 'Access Path Selection’?
» What are the Access Path auxiliaries for query Access path?
» How do you delete a access path which is referred by some other access path?
» What are the Access Path auxiliaries for query Access path?
» What is an access path in SYNON 2/E?
» What are the Access Path auxiliaries for query Access path?
» How do you delete a access path which is referred by some other access path?
» What are the Access Path auxiliaries for query Access path?
» What is an access path in SYNON 2/E?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum|
|
|