Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 04 Nov 2011 @ 09:03:35 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Insufficient memory to parse during Query Rewrite
From:   Yong Boon


Check with your Teradata Production DBA for the MaxParseTreeSegs setting in the Production.

Even though you increase @ your Windows XP, it'll fail when you run against the production server.

Second things, this is one of the vault to control lousy & complex query to enter into the system. Unfortunately, you can control this in the system level parameter instead of session level parameter.

Try to check back your query, if this could be done by through few tables instead of 1 big query, which might help you to solve the problem.



  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023