Adding Access Paths › Adding an Access Path › Adding a Resequence (RSQ) Access Path

Adding a Resequence (RSQ) Access Path

Once you add the RSQ access path, follow the instructions in the preceding section, Adding an Access Path. At the Edit Access Paths Format Entries panel, you can also identify the new key sequence order:

Changing the Key Sequence

1. Remove the old key sequence order from the Key no. column.
2. Add the new key sequence order in the Key no. column. Ascending or descending sequence can also be specified for each field in the key sequence.

Note: Lower key numbers indicate a higher key order or a major key. The key sequence numbering should be unique.