一开始的时候,可以选择默认选项(4 KB),如果行的长度很小,或者对数据的访问基本上是随机的,则更应该选择这一选项。
A good starting point is to select the default (4 KB), especially if row sizes are fairly small or when access to the data is primarily random.
如果随机访问行,那么较小的页大小让db2可以更好地利用缓冲区,因为同样的存储区域可以容纳更多页。
If rows are accessed randomly, then the smaller page size enables DB2 to make better use of the buffer, because more pages fit into the same storage area.
将生成一个随机数来确定是否选择一行(类似于以 P/100 的概率扔钱币)。
A random number will be generated to determine if a row will be selected or not (similar to flipping a coin with a probability of P/100).
应用推荐