Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 20 Oct 2005 @ 10:54:17 GMT


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


Subj:   Re: Why do I get a spool space error
 
From:   Keith_kdb

I suspect if you run the derived table in its own right, the one with the group by will return considerably less rows. Therefore when the derived table is joined to table1 following the group by less spool is required as it is in fact a much smaller table than in the other example.


Regards

Keith.



     
  <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