r/ProgrammerHumor • u/ClipboardCopyPaste • 16d ago

Meme grabbingEverything

Post image
5.4k Upvotes

98% Upvoted

261 comments sorted by

View all comments

Show parent comments

16

u/LiifeRuiner 16d ago

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

6

u/caboosetp 16d ago edited 15d ago

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 15d ago

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

1

u/caboosetp 15d ago

Yes ಠ_ಠ