Archives of the TeradataForum

Message Posted: Tue, 23 Sep 2014 @ 21:14:37 GMT

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

Hello Forum,

Could someone explain when a system defined join index is created. I ran this DDL and automatically it created a join index. Is it because of the period datatype?

     CREATE MULTISET TABLE BAKTHRO.TEST_TBL_MTH ,NO FALLBACK ,
          NO BEFORE JOURNAL,
          NO AFTER JOURNAL,
          CHECKSUM = DEFAULT,
          DEFAULT MERGEBLOCKRATIO
          (
           A_ID INTEGER TITLE 'MONTH IDENTIFIER' NOT NULL,
           B_CD VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'HOTEL CODE' NOT NULL,
           C_ID INTEGER TITLE 'ACCOUNT DIMENSION IDENTIFIER' NOT NULL,
           VRS_NM VARCHAR(100) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'VERSION MEMBER NAME' NOT NULL,
           CY_CD VARCHAR(20) CHARACTER SET LATIN NOT CASESPECIFIC TITLE 'CURRENCY CD' NOT NULL,
           A_FCT_NR DECIMAL(15,3) TITLE 'ACTUAL FACT NUMBER',
           F_FCT_NR DECIMAL(15,3) TITLE 'FORECAST FACT NUMBER',
           B_FCT_NR DECIMAL(15,3) TITLE 'BUDGET FACT NUMBER',
           BT_ID INTEGER TITLE 'BATCH  ID' NOT NULL,
           A_CTRL_JOB_ID BIGINT TITLE 'AUDIT CONTROL JOB ID',
           A_UPDT_TS TIMESTAMP(6),
           TT PERIOD(TIMESTAMP(6) WITH TIME ZONE) NOT NULL AS TRANSACTIONTIME, CURRENT TRANSACTIONTIME
     PRIMARY KEY (A_ID ,B_CD ,C_ID ,VRS_NM ,CY_CD))
     PRIMARY INDEX ( A_ID ,B_CD ,C_ID ,VRS_NM ,CY_CD )

Thanks

Roopalini

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