CSE Roadmap

Core tier · about 2 hours · 5 parts

Part 1 of 5 · 1 min read

Why this page comes first

In this module you will

  • Explain how OFFSET pagination 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 OFFSET and 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.