CREATE JOIN INDEX Syntax Elements (Temporal Form) - Analytics Database - Teradata Vantage
Temporal Table Support
- Deployment
- VantageCloud
- VantageCore
- Edition
- Enterprise
- IntelliFlex
- VMware
- Product
- Analytics Database
- Teradata Vantage
- Release Number
- 17.20
- Published
- June 2022
- ft:locale
- en-US
- ft:lastEdition
- 2023-10-30
- dita:mapPath
- eud1628112402879.ditamap
- dita:ditavalPath
- qkf1628213546010.ditaval
- dita:id
- fif1472244754791
- lifecycle
- latest
- Product Category
- Teradata Vantage™
- database_name
- Specifies an optional database name or user name specified if the join index is to be contained in a database or user other than the current database or user.
- user_name
- join_index_name
- Specifies the name given to the join index created by this statement.
- standard options
- Specifies standard table and join index options that are the same for temporal and nontemporal tables. For information about these options, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples.
- CURRENT VALIDTIME
- Specifies that the join index is current in valid time.
- The select_statement must project the valid-time column in a join index definition that is current in valid time. If the column is a derived period column, the component columns of the derived period column must be projected.
- SEQUENCED VALIDTIME
- Specifies that the join index is sequenced in valid time.
- The select_statement must project the valid-time column in a join index definition that is sequenced in valid time. If the column is a derived period column, the component columns of the derived period column must be projected.
- NONSEQUENCED VALIDTIME
- Specifies that the join index is nonsequenced in valid time.
- AND
- Specifies a keyword for specifying both a valid-time qualifier and a transaction-time qualifier. The valid-time and transaction-time qualifiers, if used together, can be specified in any order.
- CURRENT TRANSACTIONTIME
- Specifies that the join index is current in transaction time.
- The select_statement must project the transaction-time column in a join index definition that is current in transaction time. If the column is a derived period column, the component columns of the derived period column must be projected.
- NONSEQUENCED TRANSACTIONTIME
- Specifies that the join index is nonsequenced in transaction time.
- select_statement
- Specifies conventional SELECT statement syntax for creating a join index.