Archives of the TeradataForum

Message Posted: Wed, 26 Mar 2003 @ 16:52:07 GMT

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

Srini, I had experienced the same problem. The reason Volatile are not good in this situation is because you can't collect statistics. You can either use a Global Temp or a Perm table (processing), where your allowed to collect stats on both.

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