[firebird-support] Re: FB does table scan as soon as I use left outer join in view - why?

[Dmitry Yemanov dim...@users.sourceforge.net [firebird-support]]

21.08.2015 13:58, 'Louis van Alphen' wrote:

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

Right. Not very good option when you need many lookup fields from the 
same table, but could still be better than a fullscan inside join plans.


Dmitry