The Facts about THE Access Path Sharing:
Page 1 of 1
The Facts about THE Access Path Sharing:
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.
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.
Similar topics
» The Facts about THE Access Path Sharing:
» What are the Access Path auxiliaries for query Access path?
» 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 is 'Access Path Selection’?
» What are the Access Path auxiliaries for query Access path?
» 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 is 'Access Path Selection’?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum