Most devs use:
ORDER BY Id OFFSET @Skip ROWS FETCH NEXT @Take ROWS
This is painfully slow after page 5000+
because SQL scans all skipped rows.
✔ REAL FIX: Seek Pagination
SELECT TOP (@Take)
*
FROM Orders
WHERE Id > @LastSeenId
ORDER BY Id;
💡 Benefit
-
No full scans
-
No offsets
-
Linear, predictable speed