Archives of the TeradataForum

Message Posted: Fri, 08 Nov 2003 @ 00:53:41 GMT

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

"...which causes all derived tables to go to memory rather than spool."

Not so. What it does is cause derived tables to be handled as if they were views. This often saves a retrieve step and it makes possible alternate plans the optimizer would not have considered if it spooled all derived tables.

The advice to try setting internal 44 to TRUE is very good, though. The query is full of derived tables and spooling them as was always done prior to V2R5 might just allow the query to sneak by the memory limits of the parser.

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