Subject Re: [ib-support] Size of Optimiser Block exceeded
Author Ann W. Harrison
At 05:32 PM 10/8/2001 +0000, Francis Moore <moorefg@...> wrote:

>Can anyone give me any pointers as to the source of this message.

Sure, but I'm not sure it will help. The optimizer block has room for
256 interesting "things" ... here's the comment. Somehow you went over

/* the maximum number of opt items is the maximum
number of streams, conjuncts, or indices which
can be used in an rse, since this is the space
available in the opt block */

A stream is a table or view. If a table is joined to itself (directly
or indirectly) it counts as two streams. A conjunct is a boolean that
relates values from one stream with values from another. Indices are
indexes that could be used in resolving the query.

What did your query look like?


We have answers.