Archives of the TeradataForum

Message Posted: Wed, 26 Jul 2006 @ 22:33:16 GMT

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

David and Bob,

There is one wrinkle you need to be aware of when using global temp tables with tactical queries. When global temp tables are used in the macro, the plan will not be cached in the way that standard macros accessing base tables with parameterized SQL will.

This is because each session that uses that macro will have a different table ID for the GTT. Without all table IDs in the query being consistent across all executions of the macro, a generalized, cacheable plan cannot be produced.

This is also true with volatile temp tables.

Thanks, -Carrie

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