News for hackers. Stuff that matters.
Re:Ask HN: How do you test SQL? by tensor on Wednesday February 01, 2023 @10:59AM (#34612319)
Decomposing a large query into smaller subsets is the right approach, but I would strongly suggest doing it with VIEWs rather than CTEs. CTEs are a useful tool, but come with their own performance profiles and often using them too much will lead to slower queries.

There are no comments on this comment yet.