Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Derived Tables in V2R5
 
From:   Anomy Anom

<-- 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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023