Subject Re: [ib-support] Re: Indices and views
Author Christian G├╝tter
Hi Andrew,

> 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:

I think the dumb/broken optimizer is not my problem.
The problem is that even if I tell the optimizer which plan to use
it refuses to use the index
("index RDB$PRIMARY16 cannot be used in the specified plan")
which is correctly used by the select statement which joins the two

Weird, isn't it? Seems this is one for the IB/FB gurus.
BTW, I hope Helen will switch on her computer before she
furnishes the rest of her new home :-)


PS: Anyway, I tried to use the dummy WHERE clause, but the result
was still the same.