News for hackers. Stuff that matters.
Re:Ask HN: How do you test SQL? by mwigdahl on Thursday February 02, 2023 @05:43PM (#34634334)
Just tuned a query like this today. Many chained CTEs, joined together at each stage to do range checking logic within subgroups. There were so many self joins that the row estimates (and requested memory grant) were through the roof.

I love CTEs, but the query semantics matter too.

There are no comments on this comment yet.