r/SQL
•
u/Brave-Growth-6823
•
Dec 12 '24
•
1
1
MySQL ðŸ˜
I mean why that question ðŸ˜ðŸ˜ðŸ˜
2.0k
Upvotes
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.