15.10 - Example: Creating a Named Nonunique Secondary Index - Teradata Database

Teradata Database SQL Data Definition Language Syntax and Examples

prodname
Teradata Database
vrm_release
15.10
created_date
December 2015
category
Programming Reference
featnum
B035-1144-151K

This example creates a named nonunique secondary index index_2 . Index index_2 must not be an existing name in table table_2.

     CREATE INDEX index_2 (column_1) ON table_2;