Archives of the TeradataForum
Message Posted: Tue, 25 Jul 2006 @ 11:13:52 GMT
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 );
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|