TEMPORAL_DATE and TEMPORAL_TIMESTAMP in Join Indexes - Advanced SQL Engine - Teradata Database

When TEMPORAL_DATE and TEMPORAL_TIMESTAMP are used in the WHERE clause of a CREATE JOIN INDEX statement, they resolve to static values. They do not confer any temporal behavior on the join index.