About the Data Vault Administrator Guide
Introduction to the Data Vault
Data Vault Service Startup and Shutdown
Data Vault Configuration
Data Vault SSL Setup
Data Vault ODBC Setup
Data Vault Administration
Data Repartitioning
Partial Data Vault Copy
Archived Data Migration
Data Validation
Bulk File Uploader
Data Vault Administration Tool
Data Vault Logs
User Account Privileges
ssasql Command Line Program
Data Vault Audit Log
Appendix A: Sample Configuration Files
- ssa.ini
- nucleus.ini

Data Vault Administrator Guide

6.5.1
- 6.5 HotFix 1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

Alter Index Example

The following syntax shows an example of the ssasql
Alter Index command:

alter index on loyalty.customer
[drop (last_name)]
[add (phone_number]

When you run the command, the Data Vault drops the index for column last_name
in table customer
of schema loyalty
. The Data Vault creates an index for column phone_number
.

Rename Saved Search

Table of Contents

Data Vault Administrator Guide

Data Vault Administrator Guide

Alter Index Example

Alter Index Example