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]