Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2011 @ 14:00:30 GMT


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


Subj:   Re: Tune the query - giving spool space error
 
From:   Singh, Lakhwant

Is it possible for you to post the EXPLAIN plan of this SQL.

There might be columns which are being used in JOINS but are not part of PI. Have you collected stats on them as well? If not, then try that. Also, is the data huge in these tables?


Lakhwant



     
  <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