因为TPC - H工作负载中表扫描和表排序的数量较多，所以为获得最佳性能将数据从磁盘预取到内存是很重要的。
Because of the number of table scans and table sorts in the TPC-H workload, prefetching data from disks into memory is important for optimal performance.
事实上，后来的研究已经证明，在元素周期表中，元素不应该严格按照原子质量来排序。
In fact, subsequent work has shown that in a periodic table, elements should not be ordered strictly by atomic mass.
对于应用程序，加载一个包含雇员数据的简单表；该表将支持对其任何列进行排序。
For the application, load a simple table with employee data; the table will support sorting on any of its columns.
查询常常要引起对整个表的扫描，而对结果排序是这种类型的工作负载的另一种常见特征。
Queries often involve scans of entire tables, and sorting the results is another common characteristic of this type of workload.
在步骤4中，我们使SORTHEAP加倍到2048以避免排序溢出，因为某些查询需要创建临时表。
In Step 4, we doubled SORTHEAP to 2048 to avoid sort overflows because some queries needed to create temporary tables.
因此，在决定选择哪种联接方法时，优化器为内部表扫描平衡排序成本和性能优势以便促进决策。
Therefore, when deciding which join method to choose, the optimizer balances the sort cost and the performance benefit for the inner table scan to drive the decision.
但是它确实说明了创建一个能够快速排序的表非常简单，并且无需刷新页面，也不需要服务器来执行麻烦无聊的排序工作。
But it does demonstrate that it's easy to put together a table that sorts quickly, without a page refresh and without bothering the server to do the hard, uninteresting work of the sort.
对于经常用于执行排序操作的临时表空间，也应该这样。
The same is true for temporary tablespaces often used for performing sort operations.
这个xsl样式表将按商品号对订单X ML进行排序，如清单2所示。
This XSL style sheet will sort the order XML by item number, as shown in Listing 2.
两个表中的数据均可按列排序，只需点击列标题即可。
The data in both tables can be sorted by any column by clicking on the column header.
但是，我想说明的是如何在客户机上对电影表执行排序，从而为服务器减轻负载。
But I would like to show how to perform sorting of the movie table on the client as a demonstration of how to offload work from the server.
一般来说，如果内部索引是良好的集群且预测内部表被多次探测，则使用复合排序的嵌套循环联将受到优化器的青睐。
In general, a nested loop join with sort composite is favored by the optimizer if the inner index is well-clustered and the inner table is expected to be probed many times.
首先，编辑adminindexsuccess模板，并向每个表的标题添加排序链接，如清单1所示。
First, edit the AdminIndexSuccess template, and attach sorting links to each table heading, as in Listing 1.
图11显示HealthCenter的Profiling透视图，它包含一个按照活跃程度（热度）排序的最活跃方法表和一组建议。
Figure 11 shows the Health Center's Profiling perspective. It includes a table of the most active methods, sorted by activity level (hotness), and a set of recommendations.
这个portlet提供一个分页的表，让用户可以通过排序和筛选自己感兴趣的任务属性方便地监控大量任务，见图18。
The portlet provides a paging table that allows you to conveniently monitor a large number of tasks by sorting and filtering the task properties that you are interested in, as shown in Figure 18.
图2显示按WMC排序的同一个表。
客户端表可按以下标准排序。
另外一种有关循环的通用操作是排序，特别是对hash表中的键值进行排序。
Another common operation related to loops is sorting information, particularly keys in a hash.
JSpinner使您可创建一个排序的值列表，该表在选择框中每次显示一个选项，如图1所示。
JSpinner lets you create an ordered list of values, which it displays one at a time in a selection box, as shown in Figure 1.
然后它会为每个集合生成一个表，并按照集合大小排序，其中最频繁使用的大小排在前面。
It then produces a table for each collection sorted by size of collection, with the most frequent size first.
显然，您可以编写样式表来扫描整个跟踪输出，查找注释以及对它们进行排序和计数。
Obviously, you could write a stylesheet that scanned through the traced output, found the comments, and sorted and counted them.
按照典型的星型数据库设计，一个事实表包含按产品、地区和时间段排序的销售数据。
Using a typical star schema database design, a fact table might contain sales data by product, region, and time period.
最重要的是，这也是您在这里需要完成的任务，即编写一个插件来将一个简单的表转变成排序和汇总表。
Essentially, that's what you're doing here as well, writing a plug-in to turn a simple table into a sorting and summation table.
该排序后的表将用作储存关于书籍的相关信息。
The sorted list will be instantiated to store information on books.
为了建立该模型，您将定义一个通用类型表并将它用作定义一个排序表。
To model this, you will define a generic list and use it to define a sorted list.
列表3显示了样式表的条目，并定义了哪个图片用来代表这个排序箭头。
Listing 3 shows the stylesheet entry to define which image to use to represent the sort arrow.
世行正当地警告试图把那些指标转换为各国实力排序表的潜在危险，但是它是有节制的- - -毕竟利益远远超过了风险。
The World Bank rightly warns of the potential dangers of efforts to convert such indicators into league tables, but it is being too modest-the benefits far exceed the risks.
在表模式下，您可以搜索数据，删除数据，对数据排序，选择不同的排序标准等，然后使用更改后的表数据显示图表。
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.
应用推荐