分頁

這是普通的分頁技術(各大技術論壇上所謂的“高手”都這麼寫的),每頁顯示 30條資料 ，到最後執行需要 30秒，CPU占用達 50%

select [F0001],[F0002],[F0004],[F0005],[F0006],[F0007],[F0008],[F0009],[F0010],[F0011],[F0012],[F0015],[F0016],[F0017] 

from (

SELECT  

[F0001],[F0002],[F0004],[F0005],[F0006],[F0007],[F0008],[F0009],[F0010],[F0011],[F0012],[F0015],[F0016],[F0017],

ROW_NUMBER() OVER (order by [F0001]) as RowNumber FROM [T0502_T0501_View] ) as t where  

t.RowNumber between 6666600 and 6666630 order by [F0001]

分頁每頁顯示 30條資料 ，到最後需要CPU占用不到 5% ，用時不到0.3秒

select getdate()

select t.*

[F0001],

ROW_NUMBER() OVER (order by [F0001]) as RowNumber FROM [T0502_T0501_View] ) as t 

left join [T0502_T0501_View] t1 on t.f0001=t1.f0001

where  

t.RowNumber between 666600 and 666630 order by [F0001]

一點小小的分享，希望對大家有幫助！