这里DB 2仅可在一列上匹配,并且因为LASTNAME是随机的,DB 2必须执行数据排序来以LASTNAME、EMPNO顺序返回我们的行。
Here DB2 can match on only one column, and since LASTNAME is random, DB2 must do a data sort to bring our rows back in LASTNAME, EMPNO order.
一开始的时候,可以选择默认选项(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.
这张表的最后一行指出获取这样大 T值的 随机概率非常低。
The bottom row of this table tells that the probability of obtaining a T value this large by chance is very low.
应用推荐