This is exactly the problem I have with the query plan generator. I found
that I had to go through all my SQL (SPs and embedded), check each query
plan used by Interbase, and in some cases, write my own query plan

The result was that I had an app that executed faster and (most
importantly) showed all the data.

The problem is that I still don't understand what I (or Firebird) was doing
... :-)


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