Archives of the TeradataForum

Message Posted: Wed, 24 Sep 2014 @ 08:35:38 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Hi Roopalini,

System-defined join index(es) is/are automatically created when you created a table with temporal feature(s) (i.e., through the use of either VALIDTIME or TRANSACTIONTIME column, the use of PERIOD data type does not make a table temporal) and there is/are PRIMARY KEY and/or UNIQUE constraints defined.

References:

1) www.info.teradata.com/...

2) Teradata Factory Training

Best regards,

Win

	<Prev	Next>		<<First	<Prev	Next>	Last>>