This is far and away the best indexing video I have watched. Every other one barely goes into how indexing works under the hood, or use analogies that don't really make sense. Keep up the awesome content!
@Garentei Жыл бұрын
It’s not that accurate though. He used binary search instead of a B tree (though he did briefly mention it) but I think that misguides the viewer into thinking that’s also what is happening. It also fails to explain the importance of avoiding reading from disk (the whole point of using B trees over AVL or red black trees for example).
@bhargabnath57812 ай бұрын
@@GarenteiOnly after reading your comment, things seemed to make sense. Any resources for fine-tuning DB index knowledge? Please share if you got any. Thank you in advance!
@universal433412 күн бұрын
@Garentei this video is for a dumb developer, not for advanced guys. This way it gives a dumb dev bit of confidence to go further. If someone directly starts with advanced vocab and data structures, then it scares a dumb guy
@futhedude4848 Жыл бұрын
recap: 7:08 full table scan 12:26 binary search 13:56 we shouldn't add index at everything
@satyajeetsahu527010 ай бұрын
This video explained indexing so simply that I can't forget it ever!!!
@brianfan7158 ай бұрын
BEST Indexing explanation video on KZbin
@jay_wright_thats_right8 ай бұрын
It's good but it's not the best on KZbin. There are plenty of videos that all can be the BEST. You just understand this video because you lacked knowledge or understanding of words used in other videos.
@Bob-uk4bsАй бұрын
@@jay_wright_thats_right lol bro so serious 😭😭
@williamse.barreras.23252 жыл бұрын
Study it tooo long ago, recently my boss put me on the spot with ‘what is an index in db’ haha. Now I know, thanks mate. Good video
@theyayaa5 ай бұрын
I came for indexing, but couldn't help but notice that Laith is making $54 million while my boy Todd is making $27k....Laith must be the CEO
@stratboy2 Жыл бұрын
Finalyy a tut that really explains what indexes are... The only one till now. Than you!
@timmytesla96554 ай бұрын
I have watched numerous videos, but this is the best explanation so far. Kudos.
@toluajise42683 ай бұрын
In my opinion, this explanation presents a very clear analysis and straightforward approach to database indexing.
@LilMightyBeef14 күн бұрын
Thanks so much!!! You make it so much easier to understand than my Uni.
@gadgetboyplaysmc9 ай бұрын
More on the performance hit of indices on WRITES. How does it work? Does it: A. Insert the new row in the TABLE (O(1)). Find where the index should be placed (O(logn)), insert it there (O(1)). Or does it: B. Insert the new row in the TABLE (O(1)). Query the whole TABLE again (constant). Sort it again (O(idk)). Save it in the index (O(1)). --- I'm guessing A, but I'm not even sure if that's possible lol. I guess the "finding where the index should be placed" would be the slow part and most likely it would be equivalent as doing the same SELECT query for that column as well? Since you mentioned that SELECT is O(logn): Essentially writes would be O(logn). Would that be, correct?
@hiteshsuthar10973 жыл бұрын
Now i understand this system design term... Please make more videos on cool stuffs like this.
@AnshulkattaАй бұрын
I approve the simple explain award to this video on KZbin about indexing
@santoshpoudel18537 ай бұрын
i have looked up to many videos and just came across this detailed best explanation
@futhedude4848 Жыл бұрын
Great explaination, can you do B-tree and Hash in DB Indexing?
@paulo__vieira2 ай бұрын
This was way too easy to understand. Thank you for the explanation.
@javohir3073 жыл бұрын
great tutorial bro, keep it up, good luck to your channel !!
@agguLiАй бұрын
Thank you very much for the video. I have one question: What happens, if I execute a query on a non indexed column? Based on your explanation, the Blocks stay on disc and when B and I are found by an index, they can be loaded explicitly. When there is no index and I execute a query, is the "load from disc into memory" operation done at runtime? Thanks a lot
@als53213 жыл бұрын
can you do something like this for mongoDB?
@MONTI2710 Жыл бұрын
Hands down the best tutorial on index❤
@nullpointer78095 ай бұрын
But even though we significantly reduced the search time, we have increased the time required to add a record right?
@EmmanuelTkayy3 ай бұрын
lol
@AdrianAngeltveit-mr1nq7 ай бұрын
I have a program which is doing a lot of queries against a table. The problem is that the program is too slow, and it's updating many records. How can I speed it up? Can i index columns used in searches that is not getting updated? Or does indexing get slow eitherway if i update records in a table with indexed columns?
@tpa343710 ай бұрын
Is this somehow how it works in Windows when it indexes files for file search?
@hank919183 жыл бұрын
whoa! fantastic lesson! More content please!
@Cant_think_of_any7 ай бұрын
there are a lot of sh** KZbinrs who upload trash in the name of content, but you are opposite to those. Thank-you for this precise and easy on mind tutorial!
@vodapramod3 жыл бұрын
Laith, Please do a course on Database Please. Please. PLEASE
@AbuBakrSadiqi-b7t Жыл бұрын
Very well explained. Thanks for that
@tamaratayler9 ай бұрын
You explained the unexplainable, that calls for the glock glock 3000
@avishjain73752 ай бұрын
This index are stored in disk or memory?
@hiteshsuthar10973 жыл бұрын
Now i understand this system design term... Please make more videos on cool stuffs like this. also Tsm
@fiyinfo6 ай бұрын
Great explanation for database indexing. Thanks!
@abdulhamedeid9357 ай бұрын
what annotation app are you using
@ssaarahj3 жыл бұрын
Super informational! Thank you.
@victorhaynes50810 ай бұрын
Wow you made this easy. Great video
@AndySterkowitz3 ай бұрын
Great explanation.
@mohammedg4852 жыл бұрын
i was watching happily till i read the title
@lukechopper223 жыл бұрын
Very good tutorial. Thank you.
@AndrewKlem9 ай бұрын
This was so helpful. Thank you!
@seriouslyiknowhowtoread11 ай бұрын
Hands down best video
@marcusfortesАй бұрын
Great explanation! Thanks!
@uvieemma38547 ай бұрын
100% dope explanation of indexing
@SB-ew4ve2 жыл бұрын
But you don’t have to call me dumb though this is already enough 😞
@user-pp4gh4gb2w5 ай бұрын
I like Laith's salary
@stefankyriacou7151 Жыл бұрын
This was a solid explanation
@_indrid_cold_8 ай бұрын
Fantastic. Thank you very much.
@rokibulhasan20059 ай бұрын
Quality lecture. Thanks...
@dawid_dahl3 жыл бұрын
Awesome, thank you.
@shivamtodwal9117 Жыл бұрын
Best video on Indexing
@manmeetkaur713010 ай бұрын
If i understand by this video, am i dumb ?
@JessRasmussen-b1m7 ай бұрын
Apparently... I also think it s a stupid title, and to call your viewers dumb... Why?
@KamronbekAbdumannonov-m6u6 ай бұрын
Great explanation!
@sakshichadha9410 Жыл бұрын
best video so far
@potaetoupotautoe79397 ай бұрын
my kind of content
@insertnamehere49598 күн бұрын
Algorithms and Data Structures😀
@mihirkumar2788Ай бұрын
Helpful, ❤ from India
@pamdingelesi33824 ай бұрын
Laith is getting a fat check $
@zdravkobeykov3 жыл бұрын
I don't usually subscribe, but ...
@eudaimonia21208 ай бұрын
Excellent🥳
@CheekySensei7 ай бұрын
Increase to 1.5x speed for smoother flow
@tibebetech4867Ай бұрын
Excellent!
@ТатьянаЛоскутова-у3м Жыл бұрын
Amazing!!!😍
@tymo33912 жыл бұрын
great tutorial!
@anuragsekhri2315Ай бұрын
well explained
@hamed9327 Жыл бұрын
thank you so much
@ukaszkiepas578 ай бұрын
thank you very much :)
@aghilliyasha3 ай бұрын
Thank you
@babayaga68719 ай бұрын
Thank you !
@mma-dost7 ай бұрын
the title of the video is pretty much embarrassing to click on. Question to me : Am I Dumb ? No So dont click on the video.
@LahfenOrashusFofonyuy2 ай бұрын
thanks man
@harshmittal637 ай бұрын
♥
@dgimop5 ай бұрын
Watch this video on 1.25x speed. You're welcome!
@aron2922Ай бұрын
It's for dumb developers
@MuhammadAli-fn4xb7 ай бұрын
Awesome
@0sliter010 ай бұрын
I hate that you couldn't cut a wait from the animation...
@avinashsigarakanti86077 ай бұрын
developers could have explained this in 5 mins in very much better way
@overtronwindows8 ай бұрын
As a dumb developer I must say I didnt understand.