Archives of the TeradataForum

Message Posted: Mon, 05 Mar 2007 @ 23:43:46 GMT

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

This depends entirely on the SQL statement involved. If there are embedded comparison values then it will not be cached right away. Only if it is seen again with the same values. Whereas a Macro with parameter values will be immediately cached by the parsing engine and be ready for reuse.

John

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