🎙 Free live masterclass · Sun, 29 Nov, 7:00 pm IST · Java Full Stack roadmap Register free →
Skills101
← Quiz: Pagination and Sorting: all 10 questions

Quiz: Pagination and Sorting · Question 9 of 10

Why does OFFSET 100000 LIMIT 10 get slow?

Why does OFFSET 100000 LIMIT 10 get slow?

  1. A.The database still reads and discards the first 100,000 rows
  2. B.LIMIT is not supported on big tables
  3. C.Indexes are switched off for OFFSET
  4. D.The JSON becomes too large
Answer & explanation

Correct answer: The database still reads and discards the first 100,000 rows

Keyset pagination (WHERE id > last LIMIT 10) avoids walking past skipped rows.

Can you get the rest right without peeking?

Take the timed Quiz: Pagination and Sorting quiz free. Pass it to earn XP and count towards your certificate.

Start the quiz →