Heap Sort has the additional benefit of being quite consistent in its speed, so it is useful in programs where timing is crucial (i. e. networks).
堆排序的另外一个好处是它的速度非常稳定，这让它得以在那些需要严格计时的程序中派上用场(例如网络)。
Use appropriate indexes to minimize the use of the sort heap.
使用合适的索引使排序堆的使用降到最低。
For example, if there were an excessive amount of sorting such that the sort heap spilled to disk, performance would suffer.
比如说，如果出现大量排序操作，导致排序堆被溢出到磁盘上，那么性能就会受到影响。
Sorts that start after the sort heap threshold has been reached may not receive an optimum amount of memory to execute.
在到达排序堆阈值之后开始的排序可能不会接收到最合适的内存数量去执行。
The typical consumer of agent private memory is the sort heap memory that is used by the agent to sort rows during query execution.
代理私有内存的常见消费者是排序堆内存，代理在查询执行期间使用这部分内存来对记录行进行排序。
Ideally, you should set the sort heap threshold (SHEAPTHRES) parameter to a reasonable multiple of the largest SORTHEAP parameter you have in your database manager instance.
理想情况下，应当将排序堆阈值(SHEAPTHRES)参数合理地设置为在数据库管理器实例中设置的SORTHEAP参数最大值的倍数。
You can use the snapshot report to derive information such as the buffer pool hit ratio, amount of sort heap overflows, and the system workload.
您可以使用快照来获得诸如缓冲池命中率、排序堆溢出的次数以及系统工作负载之类的信息。
Information about system configuration can include the size of the buffer pool, the sort heap, and more.
关于系统配置的信息包括缓冲池的大小、排序堆的大小等等。
It works the same way for sort heap, as we'll see in the sort heap section below.
正如将在下面的排序堆一节中所看到的，它的工作方式与排序堆的相同。
If the sorted data cannot fit entirely into the sort heap, which is a block of memory that is allocated each time a sort is performed, it overflows into a temporary table owned by the database.
如果无法将排序的数据整个放入排序堆中(排序堆是每次执行排序时分配的一块内存)，它就会溢出到该数据库所有的临时表中。
Each sort has a separate sort heap that is allocated as needed, by the database manager.
每个排序都有单独的由数据库管理器按需分配的排序堆。
Tune the federated system for local processing in the areas of application heap, statement heap, buffer pool, sort heap, and temp tablespace.
为应用程序堆、语句堆、缓冲池和临时表空间这些区域中的本地处理调优联邦系统。
Examples of operations that use the sort heap include hash joins and operations where the table is in memory.
使用排序堆的操作示例包括内存中表的散列连接和操作。
The sort heap size is used by the optimizer in determining access paths.
优化器用排序堆大小来确定存取路径。
If directed by the optimizer, a smaller sort heap than the one specified by this parameter is allocated using information provided by the optimizer.
如果由优化器来指导排序堆大小的分配，那么用优化器提供的信息来分配的排序堆的大小要小于由该参数所指定的排序堆大小。
Always keep the threshold high enough to fulfill the total sort heap required by all the applications, if not application request for a piped sort will be rejected.
总是要让阈值保持足够大以便满足所有应用程序所需的总排序堆。
排序堆大小(SORTHEAP)。
Sort - Amount of heap used, overflows and sorts performed.
SORT——使用的堆、溢出和执行的排序的总数。
The Sort heap Threshold (sheapthres, sheapthres_shr).
排序堆的阈值(sheapthres, sheapthres_shr)。
It includes stack and heap information about the thread. Sort pool is used for following operations.
它包括与该线程堆栈和堆有关的信息。
If the value of Post threshold sorts ratio is high, you should either increase the sort heap threshold (sheapthres), or adjust applications to use fewer or smaller sorts via SQL query changes.
如果阈值后排序率很高，您就应该增加排序堆阈值(sheapthres)，或通过修改SQL查询调整应用程序以使用较少或较小的排序。
Tuning the sort heap threshold (sortheapthres).
调优排序堆阈值(sortheapthres)。
If the value of Piped sorts ratio is low, you should consider increasing the sort heap threshold (sheapthres) for better sort performance.
如果管道排序率的值很低，您就应该考虑增加排序堆阈值(sheapthres)以获得更高的排序性能。
As we have mentioned earlier, the agent private memory includes several memory pools such as the application heap size, sort heap size and statement heap size. (See Figure 1).
之前我们曾提到过，代理私有内存包括一些内存池，例如应用程序堆大小、排序堆大小和语句堆大小。
Post threshold sorts is the number of sorts that have requested heaps after the sort heap threshold has been exceeded.
阈值后排序(Post thresholdsort)是在超出排序堆阈值之后，请求堆的排序数目。
She scraped together the dead leaves till she had formed them into a large heap, making a sort of nest in the middle.
她把一些枯叶扫到一起，堆成一大堆，在中间扒出一个窝来。
The sort heap is a memory pool that belongs to the agent private memory set.
sort heap是属于代理私有内存集的一个内存池。
The sort heap is a memory pool that belongs to the agent private memory set.
sort heap是属于代理私有内存集的一个内存池。
应用推荐