Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 25 Jul 2006 @ 11:13:52 GMT


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


Subj:   Impact of Join index
 
From:   Swarna_Thirugnanam

Hi

     CREATE JOIN INDEX J1 ,NO FALLBACK ,
     CHECKSUM = DEFAULT AS
     SELECT A.COL1 ,
     A.COL2 ,
     A.COL3 ,
     A.COL4 ,
     B.COL1 FROM
     (TABLE 1   A
     LEFT OUTER JOIN TABLE 2  B  ON
     (A.COL3 =
     B.COL2)
     AND  (B.COL1 =  'XXXX'))
     ORDER BY A.COL1 ASC
     PRIMARY INDEX ( COL1 );

Note:

Table a has million of records and gets populated daily.

Table B is small one with thousands of records


What is the impact of the join index on an existing job of the table?

In the above sample, the post implementation of the Join index has resulted in poor performance on the deletion of table A.

Please advice whether the collect stats would help us in improving the performance.

If so suggest on the columns for which collect stats is required?


Thanks

Swarna



     
  <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: 15 Jun 2023