I think the author may have misunderstood the redundant GROUP BY columns with UNIQUE indexes. If you group by columns (A, B, C) and there is a UNIQUE index on (A, B), you can remove C (all parts not in the unique key), as there will only ever be at most one value of C due to the unique key constraint.
I think the author may have misunderstood the redundant GROUP BY columns with UNIQUE indexes. If you group by columns (A, B, C) and there is a UNIQUE index on (A, B), you can remove C (all parts not in the unique key), as there will only ever be at most one value of C due to the unique key constraint.
Interesting and comprehensive article.
Note to the author : on mobile, none of the examples are visible.
Works for me on Brave, Android 15.
I was using Firefox on IOS.
Thanks for the report!