阅读背景:

Sql Server按偏移量分页行 - 没有'ORDER BY'

来源:互联网 

A production table of mine contains over a million records. An requirement calls for a paging query to retrieve records by OFFSET and LIMIT parameters(similar to MySql's LIMIT clause), without sorting the result set, just as rows' natural order are in a table-scan, since 'ORDER BY' generates unacceptable performance impact, including 'ORDER BY' clause used in traditional technique of ROW_NUMBER() OVER (ORDER BY ...).A production table of mine contains over a mill




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: