Dmitry, re your point 4, do you mean:



create view SKIN as

select

ID,

(select NAME from COLOUR_ C where C.ID = S.COLOUR_ID)

from SKIN_ S;



I will try this thanks





From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 21 August 2015 12:25 PM
To: firebird-support@yahoogroups.com
Subject: [firebird-support] Re: FB does table scan as soon as I use left outer join in view - why?





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.

Dmitry





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