| Subject | Re: FB does table scan as soon as I use left outer join in view - why? |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2015-08-21T10:24:43Z |
21.08.2015 12:14, 'Louis van Alphen' wrote:
filter the view using another table (e.g. with IDs to be retrieved).
4) use subselects instead of left joins for lookups inside views
5) sponsor optimizer improvement
May be other workarounds are also possible.
Dmitry
> 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.
Dmitry