Mysql Index Tutorial | [Simple Explanation] [2020]

In this video, we'll see how basic Mysql Index concept works. We'll see how Mysql B-Tree index concept works with a simple example.
Power of Mysql Index: • Mysql Index Tutorial |...
Mysql Index works similar to how an index in a Book works. Mysql Indexes stored indexed column data in a separate storage in an Ordered List. When we search for a value, Mysql searches in the index column using the B-tree concept.
Mysql B-tree index works by first checking the middle value in the ordered indexed column, if the value is greater, it will continue to search on the right side of the column. If the value is lesser than the the middle value, it will search to left of the column. This method of search continues till it matches the value. This way, indexed columns need not scan all the rows of the table.
SUBSCRIBE: / @technotrax

[@davidbierman5717]

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

[@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...

[@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

[@mohdramees09]

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

[@legacyblob5385]

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

[@Alexander-ns9yv]

The best explanation of MySQL indexes.

[@colibri-n7g]

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

[@__hazelnut]

This explanation is extremely clear. Thank you so much!

[@urwashikeshari8148]

I understand this concept very well only on this video thankyou

[@slitheriotrollingman3101]

this video is so clear, many many thank u

[@clickbaitpolice9792]

the book analogy was crispy

[@dehumanizer668]

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

[@vasurupolia9481]

What an explanation! Too good.

[@SanjayKumar-un7xf]

Excellent explanations !

[@CarlLovesTopps]

Fantastic video. Really helped me conceptualize how Indexing works.

[@ujwalakuramdasu9533]

Sir, Crystal clear explanation.

[@kirikcritic3769]

Thanks for the effective example!

[@geniushomwetv9793]

Straight forward thank you

[@ps5clipx]

Thank you for this

[@thoughts2313]

Excellent explanation . God bless !!

[@achmadjulian741]

Clear explanation, Thank you!
4:40

[@spuckhafte]

omg, it was so neat!

[@smikkelbeer7890]

Thank you. Very good explanation.

[@theodoregolob4191]

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

[@meocute6807]

Great video. Thank you so much

[@kanipanama]

the best explanation. thanks :)

[@shreyaslakshminarayan1683]

Great video! Really well explained.

[@andrascsirmaz3043]

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

[@theidanking]

Great video, explained very good!

[@heshamghoniem4604]

thanks for the great and simple explanation :)

[@mislavcrnkovic2352]

Fantastic explanation! Please create more content

[@amrextracoding]

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

[@anthonyviniciusdossantosmu3062]

best video I found about the subject

[@TechnoTrax]

Thank you so much :)

[@huboohubert5299]

Thanks! :)

[@anurajms]

thank you

[@lorettashekleton5868]

That was a perfect explanation - many thanks

[@TechnoTrax]

Glad it was helpful!

[@azizbekkhushvakov2407]

Great video

[@greenzone1127]

Thanks alot

[@ayushgairola5570]

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

[@el_joker_2243]

thanks alot

[@fineas4]

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

[@nikhilchhabra4564]

short and crisp.

[@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

[@narendrasingh-di8tl]

awesome

[@fridayfirstshowtamil5177]

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

[@jessadelacruz2079]

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

[@abd_el_ouahab3824]

thanks too much

[@ltybc425]

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

[@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

[@erensrtky]

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

[@umeshdangi123]

thank you