At 04:18 PM 10/01/2006 +0000, you wrote:

>I came accross, on an application I'm starting to support with the
>following error message:
>
>ISC Error Code 335544762
>ISC Error Message
>size of optimizer block exceeded.
>
>Does anyone has some more information about this error? I couldn't
>find any information on what may be causing it or on how to deal with
>it.

It means the plan exceeds the limit of 48Kb. The only way to reduce it
will be to rewrite the query so it generates a smaller plan.

./hb