17.00 - CREATE JOIN INDEX Syntax Elements - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Release Date
September 2020
Content Type
Programming Reference
Publication ID
B035-1144-170K
Language
English (United States)
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.
join_index_name
The name of the join index created by this request. For information about naming database objects, see Teradata Vantage™ - SQL Fundamentals, B035-1141. Join index names conform to the rules for naming tables, including explicit qualification with a database or user name.