Sort syntax such as ORDER BY and GROUP BY does not necessarily cause a data sort.
ORDERBY和GROUP BY等排序语法不一定会导致数据排序。
You may also need to design indexes to avoid data sort and to provide index only access.
您也许还要设计索引以避免数据排序并提供只带索引的访问。
Now, what happens if the index that would have been ideal for DB2 to use to avoid a data sort is not an ordered list, but rather random?
现在,如果最适合DB2用于避免数据排序的索引不是有序列表,而是随机的,会发生什么?
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.
这里DB 2仅可在一列上匹配,并且因为LASTNAME是随机的,DB 2必须执行数据排序来以LASTNAME、EMPNO顺序返回我们的行。
When DB2 does not have an index in the appropriate order for sort avoidance or when DB2 USES any index the LIST PREFETCH way, then an order BY will most certainly cause a data sort.
如果DB 2没有一个适当次序的索引可以避免排序,或者当DB 2以LIST PREFETCH方法使用任何索引时,那么一个ORDERBY必定会引起数据排序。
You can search, eliminate some data, sort the data, choose different sort criteria, etc., when in table mode and then you can display the chart with the changes to the table data.
在表模式下,您可以搜索数据,删除数据,对数据排序,选择不同的排序标准等,然后使用更改后的表数据显示图表。
You can search, eliminate some data, sort the data, choose different sort criteria, etc., when in table mode and then you can display the chart with the changes to the table data.
在表模式下,您可以搜索数据,删除数据,对数据排序,选择不同的排序标准等,然后使用更改后的表数据显示图表。
应用推荐