If you really need random rows out of your results, there are much better ways of doing it.
如果你确实需要随机的返回行,我们有更为有效的方法。
Since DB2 will only use the index the "traditional" way for index-only access, the rows will be returned just like our index data, in groups of identical LASTNAMEs in random order.
因为DB 2仅将以“传统”方式使用索引,以实现仅限索引的访问,各行将像我们的索引数据一样,在同样的LASTNAME小组以随机形式返回。
After the reorganization, the index NAMES_FULL_NAME will have a very low cluster factor (close to 0), because the rows are now stored in random order.
在进行重组之后,索引NAMES_FULL_NAME将具有一个极低的群集因子(接近于0),因为现在的行是以随机次序存储的。
应用推荐