2 ms·
If EXPLAIN is little known then we have failed as educators, mentors and peers. It does amaze me the gaps that people have, though.
by hinkley 4y ago
If EXPLAIN is little known then we have failed as educators, mentors and peers.
It does amaze me the gaps that people have, though.
- haggy102 4y agoI'm glad you said it because I was about to say the exact same thing.
- krylon 4y agoMy gut feeling is that it's fairly well known, but few people use it. Including yours truly. Then again, I have rarely run into performance issues with database engines. Either the ones I've had contact with (SQLite, MSSQL, Postgres) are very good at what they do (which I suspect they are), or my requirements were too puny for them to break a sweat (which I also suspect to be the case). I did use MSSQL Studio's query analyzer once to fix a performance issue and was able to get the query in question from nearly an hour down to under a second. triumphant grin I don't remember the details of the query, but the solution was to use a hash join.