>The thing to learn from this is to try to make it easy for your optimizer
>to make its optimization, something your CREATE INDEX statements indicate
>that you have tried to avoid (and avoid helping the optimizer is asking for
>trouble).

:-) *blush* the problem is that there is very little info on how the
optimizer works that I have been able to find, so I'm a bit in the dark
here. I have frantically been converting the app to IBO so that we can use
FB (rather than IB) in the production environment, but in the mean time
need to optimize the prod DB.

Thanks for all your help - am busy trying out your suggestions now, and
then will use Helen's suggestions.

Thanks again to all

Tim


[Non-text portions of this message have been removed]