Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 12 Apr 2007 @ 19:39:23 GMT


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


Subj:   Re: Out of Spool after Collecting Statistics
 
From:   Anomy Anom

<-- Anonymously Posted: Thursday, April 12, 2007 13:20 -->

Most probably the plan before and after collect stats are different. Before stats small table may be duplicated and large table is built local or accessed directly. May be after stats plan would have changed to redistribute both the tables. If you post the explain we can easily figure out the cause for out of spool.


Regards



     
  <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