I think CTE is red herring here, the problem is in the sub-query regardless if it's in CTE or n...

zokier • 05/04/2025 • 1 reply • view on HN

I think CTE is red herring here, the problem is in the sub-query regardless if it's in CTE or not

Normal_gaussian • 05/04/2025

Yes, it is a red herring for sure; using a limit without a sort in a sub-query is always an issue.

alt Hacker News