BUFFER POOL——物理读、逻辑读和定时信息。
BUFFERPOOL - Physical reads, logical reads and timing information.
结果表明,Hilbert 曲线的确能够更好地根据拓扑聚集数据,与 Z 排序相比,它可以减少 1.5% 的数据物理读。
The result shows that indeed the Hilbert curve clusters the data better according to their topology, giving us an additional 1.5% less data physical reads, compared to the Z-ordering.
在基线上,我们看到必须从物理设备多读11%的页。
At the bottom line we see an additional 11% pages had to be read from the physical device.
应用推荐