Sort avoidance with RANDOM columns
使用RANDOM列的排序规避
Also, DB2 cannot use random order index columns as part of a sort merge join.
另外，DB 2无法在排序合并合并连接中使用随机顺序的索引列。
Note that random values were used to populate several columns.
请注意，多个列都是用随机值来填充的。
Let's look at an example of index data where one of the columns is RANDOM.
我们看一个索引数据示例，其中的一列为RANDOM。
Because like-kind values of the RANDOM column are stored together, DB2 can do an equal lookup, matching on two columns of our index.
因为random列的like值存储在一起，DB 2可以执行同样的查找，在我们索引的两个列上进行匹配。
As of DB2 9, we can also CREATE indexes with columns that we designate as RANDOM.
至于DB 29，我们也可以使用我们指定为RANDOM的列create索引。
For packed columns random packing shall be used. The type of packing shall be common in the market such as PRM or IMTP or equivalent.
填料塔内的填料应随意放置。填料类型应为市场上常见的PRM或IMTP或与其相当者。
For packed columns random packing shall be used. The type of packing shall be common in the market such as PRM or IMTP or equivalent.
填料塔内的填料应随意放置。填料类型应为市场上常见的PRM或IMTP或与其相当者。
应用推荐