Practice
Learn
← Quit
0 / 0 correct
System Design
Hard
1 of 20
Why is OFFSET 1000000 LIMIT 20 slow in most SQL databases?
A
LIMIT forces a full table lock
B
OFFSET disables indexes entirely
C
The database must walk past a million rows before returning 20
D
It sorts the table twice