URL details: use-the-index-luke.com/sql/partial-results/fetch-next-page
URL title:
OFFSET is bad for skipping previous rows
URL description:
OFFSET doesn’t deliver stable results and makes the query slow. Key-set pagination does neither.
URL last crawled:
2022-09-16
URL speed:
0.234 MB/s,
downloaded in 0.100 seconds
2 external links to this url
Only links from external domains are shown on this page.
found date
link text
from url
2024-07-24
Use the index, Luke – Paging through results
2022-07-08
Partial Results - fetch next page (offset method)