All Forums General
keerthi1987 14 posts Joined 02/16
12 Apr 2016
Insufficient memory to parse this request, during optimizer phase.

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.

listoni 5 posts Joined 02/11
13 Apr 2016

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

keerthi1987 14 posts Joined 02/16
16 Apr 2016

Hi listoni,
Thank you for your replay.

You must sign in to leave a comment.