79767791

Date: 2025-09-17 20:37:24
Score: 2
Natty:
Report link

The only reason the "group by" worked faster then the "distinct" in your example is the data was already in-cache.

I would recommend using Distinct, unless you need an aggregate of another field like SUM, MIN, MAX, AVG.

Reasons:
  • Low length (0.5):
  • No code block (0.5):
  • Low reputation (1):
Posted by: Nilesh Barai