Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020