Archives of the TeradataForum
Message Posted: Fri, 31 Jan 2014 @ 14:23:54 GMT
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.
|