Archives of the TeradataForum

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

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

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>>