Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 Jan 2014 @ 08:22:59 GMT


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


Subj:   Recommended MaxParseTreeSegs parameter value
 
From:   Bodla, Sravan Kumar

Hi Forum,

Could you please let us know what should be the default value for MaxParseTreeSegs parameter in DBS Control.

And also, please let us know what is the recommended value?

The users are not able to execute some of the complex queries and facing '3710: Insufficient memory to parse this request, during QueryRewrite phase' issue.

We have asked user to reduce the complexity of the query/tune it.

In the manual its mentioned as default is 1000 and range is 12 to 12000. However, like to know, the recommended value and does this requires a system restart to take effect?


Thanks,

Sravan.

SRAVAN KUMAR BODLA
GCC International - Technical Consultant ?



     
  <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