You can create and manage indexes on tables in the Data Vault to increase query performance. The indexes eliminate data files that do not meet the query WHERE clause filters. The indexes also help to increase the performance of row selection for columns in the WHERE clause filter.
You can create, alter, drop, and renew the indexes. You configure the directory for the index files when you install the Data Vault. When you upgrade, the installer adds the default index file directory to the
For more information, see the
Informatica Data Archive 6.2 Data Vault Administrator Guide