34,590
社区成员
发帖
与我相关
我的任务
分享
--添加索引,单独执行
CREATE INDEX ix_Admin_Admin_Name_Department ON Admin(Admin_Name, Department);
CREATE INDEX ix_News_Editor ON News(Editor);
不要那么太多不必要的公共表表达式, 你看着是清楚了, 但执行计划可能受影响。
按下面的试下:
WITH b AS
(
SELECT ROW_NUMBER() OVER(ORDER BY ID DESC) AS R1,
ID,
ClassID,
NewsTitle,
Source,
Editor,
Hits,
isLock,
isRecyle,
addTime
FROM News
INNER JOIN Admin AS a
ON a.Admin_Name = Editor AND a.Department = 2
WHERE IsRecyle = 0
AND isLock = 0
)
SELECT *
FROM b
WHERE R1 BETWEEN 35000 AND 35019