Mysql Index Tutorial | [Simple Explanation] [2020]

[@nelsonalva]

So sad you stopped making videos. Your explanations are so clear. You should have much more subscribers. Thanks for everything.

[@gattoalaparato]

The King that everyone needs but we don't deserve...

[@makarsh29]

@@gattoalaparato om pho

[@makarsh29]

@@gattoalaparato om pho

[@SiphoMkhwanazi]

I just subscribed now for the reasons you stated.

[@davidbierman5717]

Perfect explanation. The index converts a linear search O(n) to a binary search O(logn).

[@growtogether8014]

This is exactly what I was searching for. So, in layman terms it creates a new table with column on which index has been created and memory pointer locations of each associated record. Then it sorts it and applies the Binary search algorithm to search the requested column value and there by fetches the associated pointer location, which in turn takes us directly to that memory location and presents the record to user.

[@myelibrary]

This is a fantastic explanation of how MySQL indexes work , the key is how binary indexes work- great job

[@justinabosco2763]

After watching 5 other videos, finally I understand what indexing is. Thank you

[@helalabboud2193]

To be honest
I swear you are an amazing person
And a creative teacher
You deserve all respect 🙏
I hope you continue creating useful videos

[@kunaljain-l8l]

crisp explanation for a relatively difficult topic to understand/visualise

[@legacyblob5385]

I clearly understand this concept after watched your video. Clearly explained. ❤️

[@mohdramees09]

The explanation was too good, better than others out there.

[@Alexander-ns9yv]

The best explanation of MySQL indexes.

[@__hazelnut]

This explanation is extremely clear. Thank you so much!

[@colibri-n7g]

Great explanation. Helped me to get how indices work. Thank you!

[@amrextracoding]

An AMAZING explanation.
it was really helpful.
Thanks for great efforts

[@dehumanizer668]

Exactly what I needed. Thanks for both the videos. 😄👍🏼

[@CarlLovesTopps]

Fantastic video. Really helped me conceptualize how Indexing works.

[@clickbaitpolice9792]

the book analogy was crispy

[@anthonyviniciusdossantosmu3062]

best video I found about the subject

[@TechnoTrax]

Thank you so much :)

[@shreyaslakshminarayan1683]

Great video! Really well explained.

[@andrascsirmaz3043]

I agree! Like book-indexes... simple as that!

[@achmadjulian741]

Clear explanation, Thank you!
4:40

[@lorettashekleton5868]

That was a perfect explanation - many thanks

[@TechnoTrax]

Glad it was helpful!

[@vasurupolia9481]

What an explanation! Too good.

[@urwashikeshari8148]

I understand this concept very well only on this video thankyou

[@SanjayKumar-un7xf]

Excellent explanations !

[@slitheriotrollingman3101]

this video is so clear, many many thank u

[@thoughts2313]

Excellent explanation . God bless !!

[@theodoregolob4191]

Thanks for the explanation and video. I appreciate it very much!

[@ujwalakuramdasu9533]

Sir, Crystal clear explanation.

[@theidanking]

Great video, explained very good!

[@smikkelbeer7890]

Thank you. Very good explanation.

[@ltybc425]

Can you get access to that index table from MySQL console? Where is this B-tree stored?

[@kirikcritic3769]

Thanks for the effective example!

[@fineas4]

This has to be standard solution for sql querries, to be done automatically by the database software you use

[@ps5clipx]

Thank you for this

[@fridayfirstshowtamil5177]

Can u please...Upload a video for Keys...ur Awesome..really

[@mislavcrnkovic2352]

Fantastic explanation! Please create more content

[@geniushomwetv9793]

Straight forward thank you

[@spuckhafte]

omg, it was so neat!

[@heshamghoniem4604]

thanks for the great and simple explanation :)

[@kanipanama]

the best explanation. thanks :)

[@meocute6807]

Great video. Thank you so much

[@jessadelacruz2079]

So, we need to create indexes to all columns that will be using as filter or category, right?

[@mrx-qi8th]

Hi thank you for ur amazing video
It really helped and i really appreciate it
But do you plan to make video for other indexes?unique fulltext?
I mean i got the idea but i wanna know would new memory still be allocated for unique index?
And how unique index inbmemory work cuz its no longer about sorting offcourse
Could you plz make a video on that

[@erensrtky]

Great explanation, but i didn't understand how mysql orders that list by byte value though.

[@azizbekkhushvakov2407]

Great video

[@huboohubert5299]

Thanks! :)

[@ayushgairola5570]

make a video on clustered and non clustered index too.
awesome videos

[@makarsh29]

amazing

[@theDan_YT]

thank you

[@InfantTree]

This video is used to teach software engineering students in a dutch University

[@karthicknk2827]

Great, good explanation , can you explain for views, etc like this

[@nikhilchhabra4564]

short and crisp.

[@greenzone1127]

Thanks alot

[@narendrasingh-di8tl]

awesome

[@abd_el_ouahab3824]

thanks too much

[@anurajms]

thank you

[@el_joker_2243]

thanks alot