Archives of the TeradataForum

Message Posted: Wed, 20 Feb 2002 @ 00:33:39 GMT

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

I would assume looking at the explain that the accumulated transaction table definition does not match the DDL (index or column data types you are joining on are not the same) of the target table. If it did then it do this much more efficiently.

What is the DDL of the 2 tables?

Cheers

John Street
Senior Principal Consultant,
Relationship Technology Solutions for Financial Services,
NCR Limited

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