You can create an index for a table any time after you archive data to the Data Vault. For example, you archive data to the Data Vault. You identify frequently used queries that have significant performance delays. You create indexes for the tables.

The

ssasql

Create Index command uses the following syntax:

create index on <schema name>.<table name> (column name);

The following table describes the

ssasql

Create Index arguments:

Argument	Description
schema name	Required. Name of the schema that includes the table columns you want to index.
table name	Required. Name of the table that includes the columns you want to index.
(column name)	Required. Name of the columns on which you want to create an index. You can create the index on one or more columns in the table. The maximum number of columns is the maximum amount of columns in the table. Use a comma to separate multiple columns.

To create indexes on multiple tables, run the command separately for each table. If you create an index for a table that already has an index, the command fails.

After you create an index, you must renew the index if you archive more data to the table. You must drop and create an index if you repartition the table.