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

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

The Facts about THE Access Path Sharing:

View previous topic View next topic Go down

The Facts about THE Access Path Sharing:

Post  maran on Thu Jan 10, 2013 1:06 am

The Facts about THE Access Path Sharing:

Today, access path sharing is performed implicitly by the operating system. However, there are some rules that WE need to be aware of:

1. An SQL index will not share a DDS keyed logical file's access path.
2. A DDS keyed logical file will share an access path created via SQL.
3. A DDS keyed logical file will share an access path if the keys are a subset of the key fields in the existing access path and in the same order. For example, LF1 with keys K1 and K2 will share an access path that is keyed on K1, K2, and K3.
4. An SQL index will share another SQL-created access path only if the key columns are an exact match in the same order.
5. A DDS multiformatted logical file will not share existing access paths.
6. A DDS join logical file can share existing access paths.
7. The DYNSLT file-level keyword can be used to cause DDS logical files containing select/omit criteria to share an existing access path.
avatar
maran
Admin

Posts : 442
Join date : 2009-07-24

View user profile http://pmsinformationsystem.forumotion.net

Back to top Go down

View previous topic View next topic Back to top


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