> Good point, but in the case of OP, without condition, it will do a full table ... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		cryptonector on May 31, 2023 \| parent \| context \| favorite \| on: When LIMIT 9 works but LIMIT 10 hangs > Good point, but in the case of OP, without condition, it will do a full table scan. And that has nothing to do with the ORDER BY random().

tremon on June 1, 2023 [–]

Yes it does, because of LIMIT N. An unordered result set will stop after the first N matches.

cryptonector on June 2, 2023 | [–]

Now that is correct.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact