Yes I was worried about that, but I will check



Another releated question I have always had:



When I have a master with lookup as described; and many rows from the master table reference the same lookup row, is the lookup row cached after the first read or is it read for every master table row that refers to it. If I look at the diagnostic tools I use, it seems to be the latter. If the case, also very inefficient and expensive





From: firebird-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com]
Sent: 21 August 2015 01:07 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 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





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