Sort syntax such as ORDER BY and GROUP BY does not necessarily cause a data sort.
ORDERBY和GROUP BY等排序语法不一定会导致数据排序。
Remember, sort syntax such as ORDER BY does not necessarily have to cause a data sort.
记住,排序语法,比如orderBY,并不一定要引起数据排序。
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必定会引起数据排序。
If you have a long-running OPEN CURSOR, it is not because DB2 is building a result set. It is most likely because DB2 is doing a data sort at OPEN (usually to satisfy a common ORDER BY).
如果您有一个长期运行的OPENCURSOR,并不是因为DB 2正在构建一个结果集,最有可能是因为DB 2正在OPEN(通常满足一个常见orderBY)上进行数据排序。
It introduces data sort algorithm and process for sorting and optimizing of The Sour Rolling Mill nerve network model, and importantly analyse Simplex and its application on sample data sort.
介绍了酸轧机组神经网络模型的数据筛选算法及筛选优化过程,重点分析了单纯形算法及其在样本数据筛选过程中的应用。
On the one side, you have the United States government's mighty legal and security apparatus fighting for data of the most sympathetic sort: the secrets buried in a dead mass murderer's phone.
一方是美国政府强大的法律和安全机构,他们所争夺的是最能引起同情的数据:藏在制造群体谋杀的死者手机里的秘密。
Next, operators (12) and (11) can be both skipped because they are not applying any predicates, just sorting and scanning from the sorted data, and the SORT is not distincting.
接下来可以跳过操作 (12)和 (11),因为它们没有应用于断言,仅仅是排序和从排序后的数据中扫描,而 SORT不是独特的。
The data itself can have multiple sort criteria or filtered items.
数据本身可有多个排序标准或者过滤条目。
Sometimes the user may want to sort the data only on one of the available selection criteria and leave the others blank or select no criteria to sort the data by leaving all the criteria blank.
有时候,用户可能希望只根据一个可用的选择条件对数据排序,而将其他条件留空,或者不选择任何条件,将所有条件留空。
When viewing a report, the user may want to sort the data on multiple criteria.
当查看一个报告时,用户可能希望根据多个条件对数据进行排序。
Many reports required multiple passes on the data to select, aggregate, and sort the data.
许多报告需要多次传递数据,以便对数据进行选择、汇总和分类。
If the size of the data to sort is too large, the data must go to temporary files on disk and be sorted again.
如果要排序的数据太大,那么数据就必须保存到磁盘上的临时文件中,并再次进行排序。
Most business processes need to manipulate some sort of data.
大多数业务流程都需要操作某种类型的数据。
Joyce also argues that there may be legitimate privacy concerns about making this sort of data public.
乔伊斯还认为,公开这类数据,可能导致与隐私权相关的法律问题。
Data Transformation: BIRT provides support to sort, filter, group and summarize data before it is presented to the user.
数据转换:BIRT在把数据展现给用户之前,提供了对数据排序、过滤、分组、汇总的支持。
This limitation is significant because most useful stored procedures have an OUT parameter that provide some sort of data to the calling program.
这种限制非常重要,因为大多数有用的存储过程都有一个OUT参数,该参数向访问程序提供了一些数据。
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.
在表模式下,您可以搜索数据,删除数据,对数据排序,选择不同的排序标准等,然后使用更改后的表数据显示图表。
Data source controls simplify the amount of custom code that needs to be written to retrieve and bind data, and even to sort, page through, or edit data.
数据源控件减少了为检索和绑定数据甚至对数据进行排序、分页或编辑而需要编写的自定义代码的数量。
The user can sort the data based on the ID or Name.
用户可以根据ID或名称对数据排序。
For example, if you have DB2 return results in a specified order, you won't need to sort the data yourself.
例如,要让DB 2按指定顺序返回结果,您不需要自己去对数据排序。
To ensure high performance queries, be sure to add an index to any attribute you sort your data using.
为了确保高效的查询,一定要为排序的数据属性添加索引。
On the other hand, with MDC it is advisable to pre-sort the data according to the MDC dimensions.
另一方面,如果使用MDC,建议预先根据 MDC 维对数据进行排序。
Let's jump right in and talk about the sort of data, or properties, we need to store in our history stack.
我们来看看历史堆栈中需要存储的数据或属性。
Although Pixie can use an RDBMS as a storage mechanism, it doesn't decompose your object into relational data of any sort.
尽管Pixie可使用RDBMS作为存储机制,但它没有将您的对象分解成任何一种关系数据。
You can then use these specifications within XPath expressions to sort data.
然后,您可以在XPath表达式中使用这些规范来对数据进行排序。
One of the most unique things about JumpShip is the inclusion of a standard data model that gives you search, sort, data traversal and enumeration automatically.
JumpShip最独特的特性之一是其中内含了标准数据模型,可以自动进行查找、排序、数据的遍历和枚举。
The gentab library is also built to automatically deal with large amounts of data by paginating the table's data and providing an interface to sort data by column names.
gentab库还能够自动处理大量数据,方法是为表数据标页数,并提供一个接口按列名对数据排序。
应用推荐