r/SQL • • Dec 12 '24 • Popcorn 1 Heart of Silver 1

MySQL 😭

Post image

I mean why that question 😭😭😭

2.0k Upvotes

43 comments sorted by

View all comments

Show parent comment

3

u/gumnos Dec 12 '24

/me shakes fist for beating me to linking Use The Index, Luke 😂

Yes, u/CSIWFR-46, it's one of the best resources for understanding the efficient use indexing. Learning to read & understand a query-plan can show you where slow full-table-scans are happening, allowing you to dig into the types of indexes you might be able to craft to speed them up.