Part 1 of 5 · 1 min read
Why this page comes first
In this module you will
- Explain how
OFFSETpagination works, and why its cost grows with the page number. - Explain how keyset pagination avoids that growing cost.
- Use a window function to compute a row's position for paging purposes.
- Decide between
OFFSETand keyset pagination for a given use case.
Sorting, covered two pages ago, and sargable conditions, covered on the previous page, both matter directly to one extremely common real-world task. That task is paging through a large, ordered result set. This page ties them together.