15.10 - join_index_name - 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

The name of the join index created by this request. For information about naming database objects, see SQL Fundamentals, B035-1141. Join index names conform to the rules for naming tables, including explicit qualification with a database or user name.

database_name
An optional database name if the join index is to reside in a database other than the current database. A join index can be defined in a database other than the database containing the base tables represented in the join index definition.
user_name
An optional user name if the join index is to reside in a user other than the current user. A join index can be defined in a database other than the database containing the base tables represented in the join index definition.