Welcome to plsql4all.blogspot.com SQL, MYSQL, ORACLE, TERADATA, MONGODB, MARIADB, GREENPLUM, DB2, POSTGRESQL.

Friday 9 February 2018

Create secondary Index in Teradata

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;
Please provide your feedback in the comments section above. Please don't forget to follow.