Archives of the TeradataForum
Message Posted: Fri, 31 Jan 2014 @ 08:22:59 GMT
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?
SRAVAN KUMAR BODLA
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|