Subject Re: FB does table scan as soon as I use left outer join in view - why?
Author Dmitry Yemanov
21.08.2015 12:14, 'Louis van Alphen' wrote:

> Dmitry thanks for the insight. This actual puts FB in quite a different light. I have used FB since IB 5 and is my DB of choice. However this issue may prove quite problematic.

It does not cover all cases with views, only the ones when you need to
filter the view using another table (e.g. with IDs to be retrieved).

> I have 2 options: change to another DB or have a major architectural refactor.

3) use the trick I suggested
4) use subselects instead of left joins for lookups inside views
5) sponsor optimizer improvement

May be other workarounds are also possible.