| Subject | Re: FB does table scan as soon as I use left outer join in view - why? |
|---|---|
| Author | Dmitry Yemanov |
| Post date | 2015-08-21T13:08:27Z |
21.08.2015 14:26, 'Louis van Alphen' wrote:
rows will be cached inside the buffer cache.
Dmitry
> 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 expensiveFirebird never caches records. However, data pages containing lookup
rows will be cached inside the buffer cache.
Dmitry