Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 07 Jan 2011 @ 15:11:50 GMT

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

Subj:   Re: Tune the query - giving spool space error
From:   John_Wight

Also check the following:

1. Spool allocation to the userid you are running under

2. Is the userid you are using used in other processes that can be running at same time?

3. Is the query skewed badly?

4 are the tables you are referencing (or spools) skewed badly?

5 is one of the columns you are joining contain domain values that are highly skewed (i.e. big % of same value or NULL)?


  <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