Archives of the TeradataForum

Message Posted: Fri, 28 Nov 2003 @ 09:25:56 GMT

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

<-- Anonymously Posted: Thursday, November 27, 2003 21:12 -->

We are experiencing Load Users running Out of Spool while using Derived Tables. The same queries used to run perfectly pre V2R5.

As per this thread we can use Physical Tables instead of Dervived Tables, but we have very big tables and don't have so much of Perm Space available. The advantage of using Derived Tables is that we could use our Spool Reserve Buffer which is quite large and load users have a large Spool Space limit.

Who can change the following Performance Field. This is not visible in DBC Control.

44. SpoolDerivedTables = TRUE

Thanks

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