News for hackers. Stuff that matters.

A comment on Modern Data Practice and the SQL Tradition. Parent comment

Re:Modern Data Practice and the SQL Tradition by alexhutcheson on Friday November 08, 2019 @10:43AM (#21483222)
Good note. Subqueries are sometimes optimization barriers as well - it depends on query engine. If you care about performance you need to look at the query plan.
[ Parent | on HN ]
Re:Modern Data Practice and the SQL Tradition by gigatexal on Friday November 08, 2019 @11:03AM (#21483483)
"If you care about performance you need to look at the query plan." Always I would say, once your data gets above toy size.
[ Parent | on HN ]