Introduction to Access Paths › Recognizing Access Path Components › Access Path Auxiliaries

Access Path Auxiliaries

Access Path Auxiliaries refer to:

• The three different i OS objects used to implement a query access path for DDS objects. They include a logical file, a physical file, and a control language (CL) program.
• The SQL index created for an SQL-implemented access path with *IMMED index maintenance.
• The DDL index created for a DDL- implemented access path with *IMMED index maintenance.
• Auxiliaries are not applicable for DDL type file as Views are not created for DDL type file and only Index with the same name as the source member name is created.

For more information about auxiliaries, see:

• The topic Adding a Query (QRY) Access Path in the "Adding Access Paths" chapter
• The topic Modifying Access Paths in the "Modifying Access Paths" chapter