Persistence Option
You can use the Persistence option when creating or modifying a secondary index to specify that the index be recreated whenever the base table is modified. By default, indexes are created with no persistence.
In SQL, you can accomplish this task with the CREATE INDEX and MODIFY statements, and the [NO]PERSISTENCE clause. For more information, see the SQL Reference Guide.
In VDBA, this option is found in the Structure of Index and the Create Indexes dialogs.
Example: Enable the Persistence Option
For example, assuming the secondary index empidx was created without enabling the Persistence option, you can modify it to enable this feature, as follows:
modify empidx to btree with persistence;
In VDBA:
1. Open the Structure of Index dialog for the empidx index.
2. Select B-tree from the Structure drop-down list.
3. Enable the Persistence check box.