ALTER JOIN INDEX Syntax Elements

ALTER JOIN INDEX Syntax Elements - Teradata Vantage

Teradata® VantageCloud Lake

Deployment

VantageCloud

Edition

Lake

Product

Teradata Vantage

Published

January 2023

Language

English (United States)

Last Update

2024-04-03

dita:mapPath

phg1621910019905.ditamap

dita:ditavalPath

pny1626732985837.ditaval

dita:id

phg1621910019905

database_name: Name of containing database for join_index_name.; This specification is required only if the join index to be dropped is contained in a different database than the current database.
user_name: Name of containing user for join_index_name.; This specification is required only if the join index to be dropped is contained in a different user than the current user.
join_index_name: Name of the join index to be altered.
map_name: Name of an existing contiguous or sparse map. Cannot be TD_DataDictonaryMap or TD_GlobalMap.
colocation_name: [Optional] Name for colocating the join index on the same AMPs with other tables or join indexes.; Specify only for a sparse map. For a contiguous map, colocation_name is set to NULL.; If you do not specify colocation_name for a sparse map, the name defaults to database_index, where database is the name of the database or user followed by an underscore (_) and index is the name of the join index. If database exceeds 63 characters, database is truncated to 63 characters. If index exceeds 64 characters, index is truncated to 64 characters.