Archives of the TeradataForum
Message Posted: Thu, 11 Oct 2012 @ 15:09:51 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|