先来对比两段分页SQL，假设条件：news表有15万记录，NewsTypeId=10有9万记录，当前查询NewsTypeID=10。那么，你会认为哪个SQL效率会高呢？

代码如下: –代码一DECLARE cc INT SELECT NewsId,ROW_NUMBER() OVER(ORDER BY SortNum DESC) AS RowIndex INTO #tb FROM news WITH(NOLOCK) WHERE NewsTypeId=NewsTypeId AND IsShow=1 SET cc = ROWCOUNT SELECT n.* FROM news AS n WITH(NOLOCK), #tb As t WHERE t.RowIndex&g