Subject | Size of Optimiser Block Exceeded - ISC Error Message |
---|---|
Author | moorefg |
Post date | 2004-05-13T00:35:32Z |
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.
Thank you
Francis Moore
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.
Thank you
Francis Moore