Data Modeling › CA 2E Access Paths › Access Path Relations for the Retrieval Index

Access Path Relations for the Retrieval Index

The default Retrieval index access path includes all the relations that define a file; in other words, it contains all the fields in the file. The included relations are indicated by * in the D column. You can drop non-key relations in order to include a subset of fields in your logical view of the data. You can later reinstate a dropped relation.

Note that each of the two Refers to access path relations involves a reference to another access path. Any reference to another file by an access path relation is by means of an access path of the referenced file known as the referenced access path. By default this is the Retrieval index of the referenced file.