Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 31 Jan 2014 @ 14:23:54 GMT


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


Subj:   Re: Recommended MaxParseTreeSegs parameter value
 
From:   Barb.Green

While the recommended changes to this parameter are valid be aware that changing the setting may (in my case DID) cause longer parsing in some queries. When you make this change you need to monitor for this and weight the greater parsing times with the ability to parse the query. Hopefully you have DBQL turned on so you can run tests to validate.

We engaged the GSC to insure this was the appropriate action to take and that query tuning was not a better choice.

Good luck with your challenge.



     
  <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