CREATE NAMED SECONDARY INDEX in Teradata

We can assign name to the index in order to access or to drop it.

Syntax:
CREATE [UNIQUE] INDEX index_name <column-list> ON table name


If we are having tbl_employee with one of the columns like department, then the named secondary index can be defined for that column as below:
CREATE INDEX ind_dept (department) ON tbl_employee;

Since we are not specifying the word "UNIQUE", the above index will be treated as Non unique secondary index.

The next example creates a unique named secondary index(USI).
CREATE UNIQUE INDEX ind_dept (department) ON tbl_employee;