Hi,

> I have been having issues with our application and the Size of
> Optimiser Block Exceeded error message for quite a while.
>
> I have been unable to obtain any pointers as to how to increase the
> Optimiser Block or to configure queries in such a way as it is
> avoided.
>
> We have checked the Plan for all queries and have established
> indexes for all key fields.
>
> We are using IBObjects.
>
> Can anyone give some pointers as to what what/where the optimiser
> block is and how to mitigate this error message.

The limit is hard coded and cannot be changed and is "hit" when more then
255 conjunctions are build internally. So how many conditionals do you've in
your query.
Show us the complete query in question.

Regards,
Arno Brinkman
ABVisie

-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Firebird open source database (based on IB-OE) with many SQL-99 features :
http://www.firebirdsql.org
http://www.firebirdsql.info
http://www.fingerbird.de/
http://www.comunidade-firebird.org/

Support list for Interbase and Firebird users :
firebird-support@yahoogroups.com

Nederlandse firebird nieuwsgroep :
news://newsgroups.firebirdsql.info