Archives of the TeradataForum

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

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

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>>