When this query runs, the pages from the small, very frequently used tables are lost, making it necessary to re-read them when they are needed again.

当查询运行时，来自这些频繁使用的小型表的页将会丢失，这使得再次需要这些数据时就必须重新读取它们。