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.
[ Parent
| on HN ]
There are no comments on this comment yet.