下面的查询清单1说明了哪些表空间使用哪些缓冲池。
The following query Listing 1 shows which table Spaces use which buffer pools.
大型缓冲池还会对查询优化产生影响,因为更多的工作可在内存中完成。
Large buffer pools also have an effect on query optimization, since more of the work can be done in memory.
该查询只返回命中率低于90%的缓冲池。
The query returns only the buffer pools that have a lower hit ratio than 90%.
应用推荐