When you create an index, the index includes information for data files that currently exists in the table. The index is not automatically updated when you add or remove data from the indexed table. If you continue to archive data to an indexed table, you must renew the index to include the newly archived data.

For example, you archive customer data to the Data Vault on a quarterly basis. You created an index for the customer table to increase query performance. When you created the index, the customer table had 100 data files. The next quarter, you archive more data to the customer table. The customer table now includes 500 data files. If you do not renew the indexes for the customer table, the query uses the index only for the original 100 data files. Renew the index to include the new data files.

When you renew an index table, the Data Vault updates all indexes that exist for the table. The Data Vault updates the indexes for new data files that you added for the table. If you removed data files, the Data Vault marks the data files inactive in the index.

The

ssasql

Renew Index command uses the following syntax:

renew index on <schema name>.<table name>;

The following table describes the

ssasql

Renew Index arguments:

Argument	Description
schema name	Required. Name of the schema that includes the table index to renew.
table name	Required. Name of the table that includes the index to renew.

To renew indexes on multiple tables, run the command separately for each table.