HowTo: MySQL Query Optimization using EXPLAIN and Indexing

Подписаться 664

Просмотров 42 тыс.

50% 1

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.

Хобби

Опубликовано:

14 фев 2018

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 24

@beneverard7430 2 года назад

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.r3143 10 месяцев назад

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 3 года назад

Thank you, this solution just solved my problem

@danielscott853 5 лет назад

fantastic!

@fmaransatto 3 года назад

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

@gabecoelho647 5 лет назад

Thank you!

@shyamJshyam-james 5 лет назад

Nice ..Thank you

@akhileshchander5307 4 года назад

Thank you.

@markparee99 4 года назад

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 3 года назад

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

@nigrao 3 года назад

thanks buddy

@kaibellmann6395 4 года назад

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

@RealMeanHumanBean 4 года назад

if you google seanlahman sql you can get a big database of baseball data you can play with for free

@kaibellmann6395 4 года назад

@@RealMeanHumanBean thank you for your answer. you're talking about this www.seanlahman.com/baseball-archive/statistics/ ?

@RealMeanHumanBean 4 года назад

@@kaibellmann6395 yes

@deepalikmahajan7240 Месяц назад

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

@sriramtorvi7417 Год назад

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

@lassuncao 2 года назад

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

@AnthonyEbin 5 лет назад

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

@dingdongchingchong8659 5 лет назад

Same, can't understand what the heck they are saying.

@nithinkzy15 4 года назад

@@dingdongchingchong8659 Who forced you to watch that ?? When you get something be thankful and respect.. !!

@dingdongchingchong8659 4 года назад

@@nithinkzy15 I didn't. I left after venting my frustration. Thank you very much.

@errinwright 3 года назад

its 2020 man you cant say that

@errinwright 3 года назад

@Владимир Набоков I'm sure you wouldn't want Americans telling Russians to speak more clearly or to speak better english