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

SQL Data Definition Language Syntax and Examples

Product
Advanced SQL Engine
Teradata Database
Release Number
17.00
Published
September 2020
Language
English (United States)
Last Update
2021-01-23
dita:mapPath
wgr1555383704548.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1144
lifecycle
previous
Product Category
Teradata Vantage™
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.