Ah of course yes…
From: [email protected] [mailto:[email protected]] Sent: 21 August 2015 03:08 PM To: [email protected] Subject: [firebird-support] Re: FB does table scan as soon as I use left outer join in view - why? 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. Dmitry [Non-text portions of this message have been removed]
