Archives of the TeradataForum
Message Posted: Wed, 20 Feb 2002 @ 00:33:39 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|