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?


Cheers

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