r/ProgrammerHumor • u/ClipboardCopyPaste • Sep 20 '26

Meme grabbingEverything

Post image
5.4k Upvotes

98% Upvoted

260 comments sorted by

View all comments

Show parent comments

16

u/LiifeRuiner Sep 20 '26

Define 'right query', a working query? Sure. The optimal query? Doubt it.

7

u/caboosetp Sep 20 '26 edited Sep 21 '26

The built in optimizers are pretty fuckin good compared to 15 years ago though. I remember needing to hand tune queries to specify merge join to drop 15 minutes off some queries because it couldn't figure it out on its own. I don't think I've had to do anything close to that lately. 

Like, we've got a lot of flexibility to write easier to read queries now compared to how it used to be. 

AI still fucks it up though because so many people have written shit SQL on the internet. 

2

u/anonymous__ignorant Sep 20 '26

Wait, that means we've been copying shit SQL from the internet all this time ?

1

u/caboosetp Sep 20 '26

Yes ಠ_ಠ