Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Thu, 11 Oct 2012 @ 15:09:51 GMT


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


Subj:   Re: Need Help with Perfomace Issue
 
From:   Nagaraju Muriki

Hi Mahesh,

As you mentioned Explain plan is very bad...so have you checked statistics on group by columns, PI column?Are those up to date?

How many records exists in table?

I can say collecting stats on required columns will resolve the spool issue.


Thanks and regards,

Nagaraju Muriki



     
  <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: 28 Jun 2020