News for hackers. Stuff that matters.

A comment on We Can Do Better Than SQL. Parent comment

Re:We Can Do Better Than SQL by achr2 on Tuesday August 11, 2020 @10:26AM (#24120568)
CTEs do not get cached though, so they are actually quite bad for repetition without also using a temp table.
[ Parent | on HN ]
Re:We Can Do Better Than SQL by ComodoHacker on Wednesday August 12, 2020 @07:31AM (#24130918)
Depends on DBMS and version. Some are smart enough to pipeline/tie or materialize it internally.
[ Parent | on HN ]