Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   System defined join index
 
From:   Bakthavachalam, Roopalini

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016