Modifying Access Paths › Before Modifying › Trimming an Access Path

Trimming an Access Path

You can remove all virtuals from an access path using the Trim option.

To trim an Access Path

1. Zoom into the file.

   Type Z next to any relation for the selected file on the Edit Database Relations panel and press Enter.

   The Edit File Details panel displays.

2. Trim the Access Path.

   At the Edit File Details panel, enter T next to the selected access path and press Enter. Repeat the action to confirm.

   Note: You can also trim a format using the Edit Access Path Details panel.

   If you trim an access path that has Auto Add set to ALL, Auto Add is reset to ATR ONLY.