Archives of the TeradataForum

Message Posted: Thu, 13 May 2004 @ 15:07:56 GMT

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

<-- Anonymously Posted: Thursday, May 13, 2004 10:31 -->

Thanks all for the tips about COLLECT STATS on GTT's. Learned something there .. I had never pursued the issue further. But yes, indexes + stats on GTT columns are big plusses over the volatile variety of temp tables... as well as derived. Increases effiiciency of joins, whereas derived tables place limits on join options.

Back to the originator's question, I suppose GTTs offer a little bit of a debugging aid by allowing you to look at your derived data multiple times w/o rerunning the "derived" portion of query. You would want to avoid GTTs if you desire a monolithic or "self-contained" query.

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