If this is the case, a larger buffer pool is the best solution, but adding more free space to index pages may also help.
如果的确是上述情况,那么使用更大的缓冲池是最好的解决办法,但是为索引页增加更多的自由空间也有所帮助。
However, over-allocating free space may result in wasted DASD space, less data transferred per I/O, less efficient use of buffer pools and more pages to scan.
然而,过多地分配空余空间可能会产生浪费的DASD 空间,导致每次I/O 只能传输更少的数据,缓冲池的利用效率更低,并且要扫描更多的页。
However, over-allocating free space may result in wasted DASD space, less data transferred per I/O, less efficient use of buffer pools and more pages to scan.
然而,过多地分配空余空间可能会产生浪费的DASD 空间,导致每次I/O 只能传输更少的数据,缓冲池的利用效率更低,并且要扫描更多的页。
应用推荐