--- In ib-support@y..., Christian Gütter <cguetter@p...> wrote:

> This is quite strange, because the view V_BESCHR_PROJEKTE is
> a simple view for T_Projekte which is used in the first query.

Yes, possibly too simple for the engine. This may be a case of the
famous 'brain fade' that the planner succumbs to now and then. Or it
may be a case of expecting the planner to make a choice that seems
perfectly logical to us humans, but...

Anyway, try adding a dummy WHERE clause to your view to force the
engine to engage available indexes, e.g. use the index for NUMMER
thusly:

WHERE NUMMER = NUMMER

I think this was the fudge to use in this case. Don't know if that's
the best format to use, though. Others will correct me if not.

Regards,
Andrew Ferguson
-- Andrew is not controlled by monkeys. He's controlled by *a* monkey.