Insufficient memory to parse this request, during optimizer phase.

General
Enthusiast

Insufficient memory to parse this request, during optimizer phase.

Hi,

We are using Stored procedure for calculating some process in background,but while create the SP we are getting Insufficient memory space.We are googled this error,someone suggest us to split SP into multiple view's.We try that one but We are still getting same error.can anyone help us to solve this error.

2 REPLIES
Enthusiast

Re: Insufficient memory to parse this request, during optimizer phase.

Try: http://teradataforum.com/teradata/20070706_153353.htm

Could be to do with MaxParseTreeSegs. Your DBA will be able to confirm that this is set correctly.

Enthusiast

Re: Insufficient memory to parse this request, during optimizer phase.

Hi listoni,

Thank you for your replay.