So sad you stopped making videos. Your explanations are so clear. You should have much more subscribers. Thanks for everything.
@gattoalaparato3 жыл бұрын
The King that everyone needs but we don't deserve...
@makarsh2920 күн бұрын
@@gattoalaparato om pho
@makarsh2920 күн бұрын
@@gattoalaparato om pho
@davidbierman57172 жыл бұрын
Perfect explanation. The index converts a linear search O(n) to a binary search O(logn).
@fineas4 Жыл бұрын
This has to be standard solution for sql querries, to be done automatically by the database software you use
@shreyaslakshminarayan16833 жыл бұрын
Great video! Really well explained.
@andrascsirmaz30433 жыл бұрын
I agree! Like book-indexes... simple as that!
@myelibrary3 жыл бұрын
This is a fantastic explanation of how MySQL indexes work , the key is how binary indexes work- great job
@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.
@legacyblob53853 жыл бұрын
I clearly understand this concept after watched your video. Clearly explained. ❤️
@helalabboud219311 күн бұрын
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
@justinabosco276316 күн бұрын
After watching 5 other videos, finally I understand what indexing is. Thank you
@colibri-n7g2 жыл бұрын
Great explanation. Helped me to get how indices work. Thank you!
@amrextracoding3 ай бұрын
An AMAZING explanation. it was really helpful. Thanks for great efforts
@ps5clipx Жыл бұрын
Thank you for this
@__hazelnut Жыл бұрын
This explanation is extremely clear. Thank you so much!
@ltybc425 Жыл бұрын
Can you get access to that index table from MySQL console? Where is this B-tree stored?
@SanjayKumar-un7xf3 жыл бұрын
Excellent explanations !
@dehumanizer6682 жыл бұрын
Exactly what I needed. Thanks for both the videos. 😄👍🏼
@clickbaitpolice97923 жыл бұрын
the book analogy was crispy
@mrx-qi8th3 жыл бұрын
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
@fridayfirstshowtamil51772 жыл бұрын
Can u please...Upload a video for Keys...ur Awesome..really
@InfantTree2 жыл бұрын
This video is used to teach software engineering students in a dutch University
@vasurupolia94812 жыл бұрын
What an explanation! Too good.
@thoughts23138 ай бұрын
Excellent explanation . God bless !!
@urwashikeshari81483 жыл бұрын
I understand this concept very well only on this video thankyou
@anthonyviniciusdossantosmu30623 жыл бұрын
best video I found about the subject
@TechnoTrax3 жыл бұрын
Thank you so much :)
@mohdramees092 жыл бұрын
The explanation was too good, better than others out there.
@slitheriotrollingman31013 жыл бұрын
this video is so clear, many many thank u
@geniushomwetv9793 Жыл бұрын
Straight forward thank you
@CarlLovesTopps Жыл бұрын
Fantastic video. Really helped me conceptualize how Indexing works.
@spuckhafte Жыл бұрын
omg, it was so neat!
@makarsh2920 күн бұрын
amazing
@lorettashekleton5868 Жыл бұрын
That was a perfect explanation - many thanks
@TechnoTrax Жыл бұрын
Glad it was helpful!
@karthicknk28272 жыл бұрын
Great, good explanation , can you explain for views, etc like this
@erensrtky2 жыл бұрын
Great explanation, but i didn't understand how mysql orders that list by byte value though.
@theodoregolob41912 жыл бұрын
Thanks for the explanation and video. I appreciate it very much!
@el_joker_22437 ай бұрын
thanks alot
@Alexander-ns9yv2 жыл бұрын
The best explanation of MySQL indexes.
@huboohubert5299 Жыл бұрын
Thanks! :)
@smikkelbeer78902 жыл бұрын
Thank you. Very good explanation.
@jessadelacruz20793 жыл бұрын
So, we need to create indexes to all columns that will be using as filter or category, right?
@achmadjulian7412 жыл бұрын
Clear explanation, Thank you! 4:40
@anurajms Жыл бұрын
thank you
@heshamghoniem46042 жыл бұрын
thanks for the great and simple explanation :)
@meocute68073 жыл бұрын
Great video. Thank you so much
@ayushgairola55703 жыл бұрын
make a video on clustered and non clustered index too. awesome videos