Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Update SQL Spool Problem
From:   John Street

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?


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

  <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