Subject Re: FB does table scan as soon as I use left outer join in view - why?
Author Dmitry Yemanov
21.08.2015 14:26, 'Louis van Alphen' wrote:

> 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

Firebird never caches records. However, data pages containing lookup
rows will be cached inside the buffer cache.