HowTo: MySQL Query Optimization using EXPLAIN and Indexing

This shows a real-life example on how to speed up queries (drastically!) using the explain statement to examine query execution plans that have index problems.

[beneverard]

Thank you so much for sharing, your video helped debug a slow query, with a couple of indexes it's running so much faster!

[hafiza.b.r]

You are Amazing Man you Really Explain it in very simple way also adding a side note for docu updated information was really helpfull

[imansyaefulloh]

Thank you, this solution just solved my problem

[fmaransatto]

Awesome, thank you.
You should increase the microphone volume a little

[markparee]

Is there any way I can get explain output WITHOUT running the query? Can do that in other databases (e.g. Oracle, MSS, etc.)

[superztnt]

I like getting right to the point and the pace you moved. The audio was a bit quite, but overall great informative video. ty

[kaibellmann]

Great Tutorial, thanks. I would like to try it myself - any chance to get a dump of your sample database?

[deepalikmahajan]

I want to.know diff between 1.13 sec and 0.23 sec

[sriramtorvi]

My query that was taking 115 seconds now just takes 80 milliseconds after adding these indexes.

[lassuncao]

Thumbs down! Because the font was too small on the screen.

[AnthonyEbin]

Just glad you don't have an Indian accent...