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

Hi, When i execute this query in teradata V2R12,it is generating errors as "Insufficient memory to parse this request,during optimizer phase".But the same query is working fine in Teradata V2R6 Version.In my DBS control Max ParseTree setting is 6000.we have collected statistics for all the index columns.

You may be able to evaluate the MaxParseTreeSegs setting in the DBSControls, but I would consider reducing the number of items in your IN list or placing them into a table (permanent, global temp, or volatile) and use a subquery in your IN list instead.