Below is the syntax to create secondary Index in Teradata:-
CREATE INDEX INDEX_NAME (COLUMNS_NAME) ON TABLE_NAME;
Supposed we have Employee table and we need to create secondary Index on employee_id then syntax is:-
CREATE INDEX IN_EMPLID (EMPLOYEE_ID) ON EMPLOYEE;