Tap to unmute

Database Indexing for Dumb Developers

  Рет қаралды 83,699

Laith Academy

Laith Academy

Күн бұрын

Пікірлер: 84
@FreeTheFresh
@FreeTheFresh 2 жыл бұрын
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
@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).
@bhargabnath5781
@bhargabnath5781 2 ай бұрын
​@@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!
@universal4334
@universal4334 12 күн бұрын
​@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
@futhedude4848 Жыл бұрын
recap: 7:08 full table scan 12:26 binary search 13:56 we shouldn't add index at everything
@satyajeetsahu5270
@satyajeetsahu5270 10 ай бұрын
This video explained indexing so simply that I can't forget it ever!!!
@brianfan715
@brianfan715 8 ай бұрын
BEST Indexing explanation video on KZbin
@jay_wright_thats_right
@jay_wright_thats_right 8 ай бұрын
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
@Bob-uk4bs Ай бұрын
@@jay_wright_thats_right lol bro so serious 😭😭
@williamse.barreras.2325
@williamse.barreras.2325 2 жыл бұрын
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
@theyayaa
@theyayaa 5 ай бұрын
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
@stratboy2 Жыл бұрын
Finalyy a tut that really explains what indexes are... The only one till now. Than you!
@timmytesla9655
@timmytesla9655 4 ай бұрын
I have watched numerous videos, but this is the best explanation so far. Kudos.
@toluajise4268
@toluajise4268 3 ай бұрын
In my opinion, this explanation presents a very clear analysis and straightforward approach to database indexing.
@LilMightyBeef
@LilMightyBeef 14 күн бұрын
Thanks so much!!! You make it so much easier to understand than my Uni.
@gadgetboyplaysmc
@gadgetboyplaysmc 9 ай бұрын
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?
@hiteshsuthar1097
@hiteshsuthar1097 3 жыл бұрын
Now i understand this system design term... Please make more videos on cool stuffs like this.
@Anshulkatta
@Anshulkatta Ай бұрын
I approve the simple explain award to this video on KZbin about indexing
@santoshpoudel1853
@santoshpoudel1853 7 ай бұрын
i have looked up to many videos and just came across this detailed best explanation
@futhedude4848
@futhedude4848 Жыл бұрын
Great explaination, can you do B-tree and Hash in DB Indexing?
@paulo__vieira
@paulo__vieira 2 ай бұрын
This was way too easy to understand. Thank you for the explanation.
@javohir307
@javohir307 3 жыл бұрын
great tutorial bro, keep it up, good luck to your channel !!
@agguLi
@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
@als5321
@als5321 3 жыл бұрын
can you do something like this for mongoDB?
@MONTI2710
@MONTI2710 Жыл бұрын
Hands down the best tutorial on index❤
@nullpointer7809
@nullpointer7809 5 ай бұрын
But even though we significantly reduced the search time, we have increased the time required to add a record right?
@EmmanuelTkayy
@EmmanuelTkayy 3 ай бұрын
lol
@AdrianAngeltveit-mr1nq
@AdrianAngeltveit-mr1nq 7 ай бұрын
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?
@tpa3437
@tpa3437 10 ай бұрын
Is this somehow how it works in Windows when it indexes files for file search?
@hank91918
@hank91918 3 жыл бұрын
whoa! fantastic lesson! More content please!
@Cant_think_of_any
@Cant_think_of_any 7 ай бұрын
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!
@vodapramod
@vodapramod 3 жыл бұрын
Laith, Please do a course on Database Please. Please. PLEASE
@AbuBakrSadiqi-b7t
@AbuBakrSadiqi-b7t Жыл бұрын
Very well explained. Thanks for that
@tamaratayler
@tamaratayler 9 ай бұрын
You explained the unexplainable, that calls for the glock glock 3000
@avishjain7375
@avishjain7375 2 ай бұрын
This index are stored in disk or memory?
@hiteshsuthar1097
@hiteshsuthar1097 3 жыл бұрын
Now i understand this system design term... Please make more videos on cool stuffs like this. also Tsm
@fiyinfo
@fiyinfo 6 ай бұрын
Great explanation for database indexing. Thanks!
@abdulhamedeid935
@abdulhamedeid935 7 ай бұрын
what annotation app are you using
@ssaarahj
@ssaarahj 3 жыл бұрын
Super informational! Thank you.
@victorhaynes508
@victorhaynes508 10 ай бұрын
Wow you made this easy. Great video
@AndySterkowitz
@AndySterkowitz 3 ай бұрын
Great explanation.
@mohammedg485
@mohammedg485 2 жыл бұрын
i was watching happily till i read the title
@lukechopper22
@lukechopper22 3 жыл бұрын
Very good tutorial. Thank you.
@AndrewKlem
@AndrewKlem 9 ай бұрын
This was so helpful. Thank you!
@seriouslyiknowhowtoread
@seriouslyiknowhowtoread 11 ай бұрын
Hands down best video
@marcusfortes
@marcusfortes Ай бұрын
Great explanation! Thanks!
@uvieemma3854
@uvieemma3854 7 ай бұрын
100% dope explanation of indexing
@SB-ew4ve
@SB-ew4ve 2 жыл бұрын
But you don’t have to call me dumb though this is already enough 😞
@user-pp4gh4gb2w
@user-pp4gh4gb2w 5 ай бұрын
I like Laith's salary
@stefankyriacou7151
@stefankyriacou7151 Жыл бұрын
This was a solid explanation
@_indrid_cold_
@_indrid_cold_ 8 ай бұрын
Fantastic. Thank you very much.
@rokibulhasan2005
@rokibulhasan2005 9 ай бұрын
Quality lecture. Thanks...
@dawid_dahl
@dawid_dahl 3 жыл бұрын
Awesome, thank you.
@shivamtodwal9117
@shivamtodwal9117 Жыл бұрын
Best video on Indexing
@manmeetkaur7130
@manmeetkaur7130 10 ай бұрын
If i understand by this video, am i dumb ?
@JessRasmussen-b1m
@JessRasmussen-b1m 7 ай бұрын
Apparently... I also think it s a stupid title, and to call your viewers dumb... Why?
@KamronbekAbdumannonov-m6u
@KamronbekAbdumannonov-m6u 6 ай бұрын
Great explanation!
@sakshichadha9410
@sakshichadha9410 Жыл бұрын
best video so far
@potaetoupotautoe7939
@potaetoupotautoe7939 7 ай бұрын
my kind of content
@insertnamehere4959
@insertnamehere4959 8 күн бұрын
Algorithms and Data Structures😀
@mihirkumar2788
@mihirkumar2788 Ай бұрын
Helpful, ❤ from India
@pamdingelesi3382
@pamdingelesi3382 4 ай бұрын
Laith is getting a fat check $
@zdravkobeykov
@zdravkobeykov 3 жыл бұрын
I don't usually subscribe, but ...
@eudaimonia2120
@eudaimonia2120 8 ай бұрын
Excellent🥳
@CheekySensei
@CheekySensei 7 ай бұрын
Increase to 1.5x speed for smoother flow
@tibebetech4867
@tibebetech4867 Ай бұрын
Excellent!
@ТатьянаЛоскутова-у3м
@ТатьянаЛоскутова-у3м Жыл бұрын
Amazing!!!😍
@tymo3391
@tymo3391 2 жыл бұрын
great tutorial!
@anuragsekhri2315
@anuragsekhri2315 Ай бұрын
well explained
@hamed9327
@hamed9327 Жыл бұрын
thank you so much
@ukaszkiepas57
@ukaszkiepas57 8 ай бұрын
thank you very much :)
@aghilliyasha
@aghilliyasha 3 ай бұрын
Thank you
@babayaga6871
@babayaga6871 9 ай бұрын
Thank you !
@mma-dost
@mma-dost 7 ай бұрын
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.
@LahfenOrashusFofonyuy
@LahfenOrashusFofonyuy 2 ай бұрын
thanks man
@harshmittal63
@harshmittal63 7 ай бұрын
@dgimop
@dgimop 5 ай бұрын
Watch this video on 1.25x speed. You're welcome!
@aron2922
@aron2922 Ай бұрын
It's for dumb developers
@MuhammadAli-fn4xb
@MuhammadAli-fn4xb 7 ай бұрын
Awesome
@0sliter0
@0sliter0 10 ай бұрын
I hate that you couldn't cut a wait from the animation...
@avinashsigarakanti8607
@avinashsigarakanti8607 7 ай бұрын
developers could have explained this in 5 mins in very much better way
@overtronwindows
@overtronwindows 8 ай бұрын
As a dumb developer I must say I didnt understand.
@mannixd752
@mannixd752 8 ай бұрын
DUMP? Well,....
@priyankawagh5217
@priyankawagh5217 4 ай бұрын
Thank you!
Understanding B-Trees: The Data Structure Behind Modern Databases
12:39
Database Indexing Explained (with PostgreSQL)
18:19
Hussein Nasser
Рет қаралды 325 М.
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН
99.9% IMPOSSIBLE
00:24
STORROR
Рет қаралды 31 МЛН
To Brawl AND BEYOND!
00:51
Brawl Stars
Рет қаралды 17 МЛН
Learn Database Normalization - 1NF, 2NF, 3NF, 4NF, 5NF
28:34
Decomplexify
Рет қаралды 2,2 МЛН
Querying 100 Billion Rows using SQL, 7 TB in a single table
9:07
Arpit Agrawal (Elastiq.AI)
Рет қаралды 56 М.
Dear Game Developers, Stop Messing This Up!
22:19
Jonas Tyroller
Рет қаралды 788 М.
What is DATABASE SHARDING?
8:56
Gaurav Sen
Рет қаралды 956 М.
I made maps that show time instead of space
10:44
Václav Volhejn
Рет қаралды 1 МЛН
Clustered vs. Nonclustered Index Structures in SQL Server
8:04
Voluntary DBA
Рет қаралды 669 М.
HTTPS, SSL, TLS & Certificate Authority Explained
43:29
Laith Academy
Рет қаралды 153 М.
ACID Properties in Databases With Examples
4:57
ByteByteGo
Рет қаралды 156 М.
Quilt Challenge, No Skills, Just Luck#Funnyfamily #Partygames #Funny
00:32
Family Games Media
Рет қаралды 55 МЛН