Archives of the TeradataForum

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

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

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>>