Subject | Size of optimizer block exceeded |
---|---|
Author | Peter Ypenburg |
Post date | 2004-02-10T14:45:45Z |
Hi All,
When I run my program I get the following error:
Size of optimizer block exceeded.
I am running FB 1.0. I think it has to do with the where clause being to
big as I have 280 and conditions in the where clause. I have about 290
fields on my table and I have to make sure that I select the row where
280 of those fields are unique.
Is there a limit to the size of the where clause and limitations on
number of conditions in the where clause?
Thank you,
Peter Y
When I run my program I get the following error:
Size of optimizer block exceeded.
I am running FB 1.0. I think it has to do with the where clause being to
big as I have 280 and conditions in the where clause. I have about 290
fields on my table and I have to make sure that I select the row where
280 of those fields are unique.
Is there a limit to the size of the where clause and limitations on
number of conditions in the where clause?
Thank you,
Peter Y