Archives of the TeradataForum

Message Posted: Fri, 07 Jul 2006 @ 14:10:26 GMT

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

Hi Emanuel Alejandro,

How much is the spool space allocated to the user who is facing this issue?

Did you check the stats for the joining columns?

Use "diagnostic helpstats on for session;" followed by explaining your SQL which will tell you the optimizer recommendations for the collect stats.

Anyway none of the PI will be used as they are not fully qualified in the join condition.

Hope that helps!

Thanks, Vivek

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