What is access path? How many types & explain each.
Page 1 of 1
What is access path? How many types & explain each.
Access path is path through which you can retrieve records. There are 6 types of access path is
supported by SYNON. By default Synon creates 3 access path namely Physical, Update and
Retrieve access paths.
1. ‘PHY’: Physical file: Arrival sequence access path defining the based-on file. For a given
AllFusion 2E file there may only be one access path of type PHY - the path will automatically be
created by AllFusion 2E.
2. ‘UPD’: Update: Access path used for update. Path is keyed on AllFusion 2E fields that identify
the file. For a given AllFusion 2E file there may be several different access paths of type
UPD, each containing a different combination of fields. A default update path containing all
fields will automatically be created by AllFusion 2E.
3. ‘RTV’: Retrieval: Access path used to retrieve records from file. The key order cannot be
changed. For a given AllFusion 2E file there may be many access path of type RTV - a default
path, keyed on the identifying fields for the file, will automatically be created by AllFusion 2E.
Each ‘RTV’ access path has an associated 'UPD' access path.
4. ‘RSQ’: Resequence: Access path used to retrieve records from file using an alternative key
order. For a given AllFusion 2E file there may be many access paths of type 'RSQ'.
5. 'QRY' : Query: Access path used to retrieve records from file using an alternative key
order which may include virtual fields. For a given AllFusion 2E file there may be many
access paths of type 'QRY'.
6. ‘SPN’: Span: Access path used to span several different files using an alternative key order.
For a given AllFusion 2E file there may be many access paths of type 'SPN'.
supported by SYNON. By default Synon creates 3 access path namely Physical, Update and
Retrieve access paths.
1. ‘PHY’: Physical file: Arrival sequence access path defining the based-on file. For a given
AllFusion 2E file there may only be one access path of type PHY - the path will automatically be
created by AllFusion 2E.
2. ‘UPD’: Update: Access path used for update. Path is keyed on AllFusion 2E fields that identify
the file. For a given AllFusion 2E file there may be several different access paths of type
UPD, each containing a different combination of fields. A default update path containing all
fields will automatically be created by AllFusion 2E.
3. ‘RTV’: Retrieval: Access path used to retrieve records from file. The key order cannot be
changed. For a given AllFusion 2E file there may be many access path of type RTV - a default
path, keyed on the identifying fields for the file, will automatically be created by AllFusion 2E.
Each ‘RTV’ access path has an associated 'UPD' access path.
4. ‘RSQ’: Resequence: Access path used to retrieve records from file using an alternative key
order. For a given AllFusion 2E file there may be many access paths of type 'RSQ'.
5. 'QRY' : Query: Access path used to retrieve records from file using an alternative key
order which may include virtual fields. For a given AllFusion 2E file there may be many
access paths of type 'QRY'.
6. ‘SPN’: Span: Access path used to span several different files using an alternative key order.
For a given AllFusion 2E file there may be many access paths of type 'SPN'.
Similar topics
» What are the various types of 'Access Path' maintenance?
» 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 '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 'Access Path Selection’?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|