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.

The Facts about THE Access Path Sharing:

Go down

Access - The Facts about THE Access Path Sharing: Empty The Facts about THE Access Path Sharing:

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