TOP N 和SET ROWCOUNT N 哪个更快?
浏览:64日期:2023-05-25
懒得翻译了,大意:在有合适的索引的时候,Top n和set rowcount n是一样快的。但是对于一个无序堆来说,top n更快。原理自己看英文去。Q. Is using the TOP N clause faster than using SET ROWCOUNT N to return a specific number of rows from a query? A. With proper indexes, the TOP N clause and SET ROWCOUNT N statement are equally fast, but with unsorted input from a heap, TOP N is faster. With unsorted input, the TOP N operator uses a small internal sorted temporary table in which it replaces only the last row. If the input is nearly sorted, the TOP N engine must delete or insert the last row only a few times. Nearly sorted means you're dealing with a heap with ordered inserts for the initial population and without many updates, deletes, forwarding pointers, and so on afterward.A nearly sorted heap is more efficient to sort than sorting a huge table. In a test that used TOP N to sort a table with the same number of rows but with unordered inserts, TOP N was not as efficient anymore. Usually, the I/O time is the same both with an index and without; however, without an index SQL Server must do a complete table scan. Processor time and elapsed time show the efficiency of the nearly sorted heap. The I/O time is the same because SQL Server must read all the rows either way.
相关文章:
热门推荐

- 分析ABA问题的本质及其解决办法
- 1.浅析NIO系列之TCP
- 2.ASP.NET中为GridView添加删除提示框
- 3.f'https://google.com/search?q = {query}'中的soup.select('。r a')带回PythonBeautifulSoup中的
- 4.小白必看toString(),String.valueOf,(String)强转
- 5.带你快速上手Servlet
- 6.gitee怎么读
- 7.聊聊在Servlet中怎么上传文件
- 8.不同于其它大部分的SQL数据库引擎SQLite
- 9.Vue实现鼠标经过文字显示悬浮框效果的示例代码
- 10.pl/sql developer中TIMESTAMP的显示格式
