sql count(1)不要和查询数据混用 非常耗时
count(1)不要和查询数据混用 非常耗时
例子:
SELECT w.[PKID], COUNT(1) OVER() AS TotalCountFROM w WITH(NOLOCK)INNER JOIN s WITH(NOLOCK) ON s.PKID= w.SIDINNER JOIN s2 WITH (NOLOCK) ON s2.PKID= w.SID2INNER JOIN w2 AS WTLWITH(NOLOCK) ON W2.WID=w.PKIDORDER BY w.PKID OFFSET 0 ROW FETCH NEXT 15 ROW ONLY
登录后复制
©著作权归作者所有:来自51CTO博客作者mb60854e935d6fd的原创作品,如需转载,请注明出处,否则将追究法律责任