Archives of the TeradataForum

Message Posted: Wed, 22 Mar 2000 @ 09:10:29 GMT

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

Rudel,

I think you may be correct. Using a global temp table means that you can collect statistics on it (which you cannot do on a volatile temp table) and this may be very important to your processing. Obviously, if your processing doesn't require the existence of statistics - and a lot of processing doesn't - then I don't think this aspect makes any difference.

Regards,

Dave

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