News for hackers. Stuff that matters.

A comment on 14,000x Speedup (2015). Parent comment

Re:14,000x Speedup (2015) by naruvimama on Tuesday October 13, 2020 @01:41PM (#24767839)
The vast majority of SQL is written or managed by business users. It is a good idea to let the engine optimize the code.

And it is a dsl the planner is expected to be very good. Perhaps the next version will always fix it.

[ Parent | on HN ]
Re:14,000x Speedup (2015) by nullsense on Tuesday October 13, 2020 @07:37PM (#24771590)
It can't automagically not do stupid things if you feed it a query that will make it do stupid things. You still have to know certain things about how queries will try to fetch data.
[ Parent | on HN ]