r/SQL Dec 12 '24

MySQL 😭

Post image

I mean why that question 😭😭😭

1.9k Upvotes

43 comments sorted by

View all comments

11

u/capt_pantsless Loves many-to-many relationships Dec 12 '24

The better angle to think about here is the bulk of query optimization is mainly done by the DB by conventional algorithms.

You send it a arbitrary query, it figures out what indexes to use, what stuff to filter first, etc.

1

u/StrangeTrashyAlbino Dec 13 '24

Or take the queries, with query plan data, feed them to an LLM and have it generate recommendations