News for hackers. Stuff that matters.

A comment on Finding unique items: hash vs. sort. Parent comment

Re:Finding unique items: hash vs. sort by perl4ever on Wednesday January 08, 2020 @12:24AM (#21988601)
People tend to believe the order of query results without ORDER BY is deterministic.
[ Parent | on HN ]
Re:Finding unique items: hash vs. sort by yxhuvud on Wednesday January 08, 2020 @02:02AM (#21989030)
Also, the query optimizer are more eager to use indices when ordered.
[ Parent | on HN ]