-
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.
代理私有内存的常见消费者是排序堆内存,代理在查询执行期间使用这部分内存来对记录行进行排序。