The Facts about THE Access Path Sharing:

Go down

The Facts about THE Access Path Sharing:

Post  Archana K on Sun Jan 27, 2013 6:18 pm

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.

Archana K

Posts : 76
Join date : 2013-01-27
Age : 27
Location : chennai

View user profile

Back to top Go down

Back to top

- Similar topics

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