Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 03 May 2005 @ 16:33:11 GMT


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


Subj:   MaxParseTreeSegs & OptMaxGlobalJI
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, May 03, 2005 11:17 -->

We are running into the 3710 error (error stating that the Optimizer phase has insufficient memory to parse the request) and when reading the Teradata documentation it suggest changing the values of the MaxParseTreeSegs & OptMaxGlobalJI.

1. It doesn't really specify what I should set these to or how high I should set these.

2. What are the ramifications of setting these? Is there a point in which I will do more harm than good?


If there is anyone out there that have dealt with these parameters I would like to hear your input.


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: 27 Dec 2016